trees
1,914 rows where qSpecies_id = 45 sorted by Longitude
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
87 | 259654 | DPW Maintained 1 | :: 45 | 101x Cora St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
88 | 259653 | DPW Maintained 1 | :: 45 | 99x Cora St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
89 | 259623 | DPW Maintained 1 | :: 45 | 1498x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
94 | 260654 | Permitted Site 7 | :: 45 | 2590 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3.5x3 | ||||||||||||
103 | 253831 | DPW Maintained 1 | :: 45 | 699X Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | |||||||||||||
2087 | 261314 | Permitted Site 7 | :: 45 | 2601 Divisadero St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/31/2019 12:00:00 AM | 3 | 6x106 | ||||||||||||
2635 | 259636 | DPW Maintained 1 | :: 45 | 98x Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
3035 | 259640 | DPW Maintained 1 | :: 45 | 198x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
4471 | 259626 | DPW Maintained 1 | :: 45 | 1499x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
4568 | 253833 | DPW Maintained 1 | :: 45 | 607 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | |||||||||||||
4944 | 259613 | DPW Maintained 1 | :: 45 | 1000 Visitacion Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
5006 | 259624 | DPW Maintained 1 | :: 45 | 1401x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
5098 | 251531 | DPW Maintained 1 | :: 45 | 2100X 20th St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/15/2017 12:00:00 AM | 3 | 4x11 | ||||||||||||
6366 | 117001 | DPW Maintained 1 | :: 45 | 1X Bernal Heights Blvd | 1 | Front Yard : Yard | Tree | DPW 1 | |||||||||||||||
6535 | 259627 | DPW Maintained 1 | :: 45 | 1499x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
8424 | 261322 | Private 9 | :: 45 | 811 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/2020 12:00:00 AM | 3 | 3x3 | ||||||||||||
10803 | 259618 | DPW Maintained 1 | :: 45 | 1200x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
12379 | 259619 | DPW Maintained 1 | :: 45 | 1200x Visitacion Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
12908 | 259612 | DPW Maintained 1 | :: 45 | 1000 Visitacion Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
14450 | 259622 | DPW Maintained 1 | :: 45 | 1498x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
14847 | 259625 | DPW Maintained 1 | :: 45 | 1401x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
15760 | 251532 | DPW Maintained 1 | :: 45 | 2100X 20th St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/15/2017 12:00:00 AM | 3 | 4x11 | ||||||||||||
15847 | 259635 | DPW Maintained 1 | :: 45 | 98x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
16880 | 259621 | DPW Maintained 1 | :: 45 | 1398x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
17295 | 259617 | DPW Maintained 1 | :: 45 | 1200x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
17929 | 259649 | DPW Maintained 1 | :: 45 | 700 Delta St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
17931 | 259643 | DPW Maintained 1 | :: 45 | 241 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
18667 | 259652 | DPW Maintained 1 | :: 45 | 99x Cora St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
18887 | 259638 | DPW Maintained 1 | :: 45 | 99x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
19114 | 259651 | DPW Maintained 1 | :: 45 | 598x Rutland St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
91643 | 97034 | Property Tree 8 | :: 45 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
98915 | 199651 | DPW Maintained 1 | :: 45 | 0 | 37 | : | Tree | Private 2 | 0 | Width 0ft | 6018297.01834 | 2097895.80454 | 37.7414476037323 | -122.379309965799 | (37.7414476037323, -122.379309965799) | 10 | 3 | 8 | 58 | 1 | |||
130099 | 6759 | DPW Maintained 1 | :: 45 | 1275 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2015 12:51:00 PM | 3 | 3x3 | 6017200.09768 | 2096971.16598 | 37.7388481798969 | -122.383038438091 | (37.7388481798969, -122.383038438091) | 10 | 3 | 8 | 58 | 1 | ||
35508 | 3826 | DPW Maintained 1 | :: 45 | 120 Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/1992 12:00:00 AM | 3 | 3X3 | 6016868.5122165 | 2095917.6664165 | 37.7359371538987 | -122.384111573291 | (37.7359371538987, -122.384111573291) | 10 | 3 | 8 | 58 | 1 | ||
1851 | 200636 | DPW Maintained 1 | :: 45 | 1301 Quesada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6016782.3625 | 2093458.8747 | 37.7291810369364 | -122.384238246013 | (37.7291810369364, -122.384238246013) | 10 | 3 | 8 | 58 | 1 | |||
70303 | 190657 | DPW Maintained 1 | :: 45 | 301 Mendell St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6016835.36544 | 2097808.79392 | 37.7411279765664 | -122.38435784694 | (37.7411279765664, -122.38435784694) | 10 | 3 | 8 | 58 | 1 | |||
2464 | 190663 | DPW Maintained 1 | :: 45 | 1360 Fairfax Ave | 5 | : | Tree | Private 2 | 2 | Width 3ft | 6016747.40621 | 2097393.16894 | 37.7399818904553 | -122.384633036796 | (37.7399818904553, -122.384633036796) | 10 | 3 | 8 | 58 | 1 | |||
126949 | 190660 | DPW Maintained 1 | :: 45 | 1395 Fairfax Ave | 2 | : | Tree | Private 2 | 3 | Width 4ft | 6016617.23425 | 2097405.156 | 37.7400076047554 | -122.385083956852 | (37.7400076047554, -122.385083956852) | 10 | 3 | 8 | 58 | 1 | |||
143318 | 190675 | DPW Maintained 1 | :: 45 | 1381 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6016616.1402 | 2097404.54592 | 37.7400058690806 | -122.385087697166 | (37.7400058690806, -122.385087697166) | 10 | 3 | 8 | 58 | 1 | |||
110361 | 6809 | DPW Maintained 1 | :: 45 | 1400X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016539.97847 | 2097547.42551 | 37.7403939741954 | -122.385360989424 | (37.7403939741954, -122.385360989424) | 10 | 3 | 8 | 58 | 1 | ||
86162 | 254706 | Permitted Site 7 | :: 45 | 1443 Hudson Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 03/20/2018 12:00:00 AM | 3 | 6016508.44225 | 2096807.14943 | 37.7383595811637 | -122.385418455981 | (37.7383595811637, -122.385418455981) | 10 | 3 | 8 | 58 | 1 | |||
109923 | 254704 | Permitted Site 7 | :: 45 | 1443 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 03/20/2018 12:00:00 AM | 3 | 6016508.44225 | 2096807.14943 | 37.7383595811637 | -122.385418455981 | (37.7383595811637, -122.385418455981) | 10 | 3 | 8 | 58 | 1 | |||
154536 | 254705 | Permitted Site 7 | :: 45 | 1443 Hudson Ave | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 03/20/2018 12:00:00 AM | 3 | 6016508.44225 | 2096807.14943 | 37.7383595811637 | -122.385418455981 | (37.7383595811637, -122.385418455981) | 10 | 3 | 8 | 58 | 1 | |||
169546 | 254703 | Permitted Site 7 | :: 45 | 1443 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 03/20/2018 12:00:00 AM | 3 | 6016508.44225 | 2096807.14943 | 37.7383595811637 | -122.385418455981 | (37.7383595811637, -122.385418455981) | 10 | 3 | 8 | 58 | 1 | |||
25967 | 6810 | DPW Maintained 1 | :: 45 | 1400X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016518.03729 | 2097563.61739 | 37.74043721991 | -122.38543798217 | (37.74043721991, -122.38543798217) | 10 | 3 | 8 | 58 | 1 | ||
180694 | 200626 | DPW Maintained 1 | :: 45 | 1370 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6016343.0854 | 2094895.2737 | 37.7331008048792 | -122.385856958672 | (37.7331008048792, -122.385856958672) | 10 | 3 | 8 | 58 | 1 | |||
244 | 200570 | DPW Maintained 1 | :: 45 | 1445 La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6016341.8296 | 2095299.657 | 37.7342110910182 | -122.385889477594 | (37.7342110910182, -122.385889477594) | 10 | 3 | 8 | 58 | 1 | |||
127885 | 190661 | DPW Maintained 1 | :: 45 | 1400 Fairfax Ave | 12 | : | Tree | Private 2 | 7 | Width 3ft | 6016311.59703 | 2097718.64456 | 37.7408514692121 | -122.386162583062 | (37.7408514692121, -122.386162583062) | 10 | 3 | 8 | 58 | 1 | |||
95387 | 14993 | DPW Maintained 1 | :: 45 | 1445 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 6016309.01096 | 2097636.9306 | 37.7406269561715 | -122.38616582959 | (37.7406269561715, -122.38616582959) | 10 | 3 | 8 | 58 | 1 | ||
36523 | 190662 | DPW Maintained 1 | :: 45 | 1498 Fairfax Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6016277.57069 | 2097744.40559 | 37.7409203204163 | -122.386282030116 | (37.7409203204163, -122.386282030116) | 10 | 3 | 8 | 58 | 1 | |||
178446 | 190659 | DPW Maintained 1 | :: 45 | 1461 Fairfax Ave | 5 | : | Tree | Private 2 | 6 | Width 3ft | 6016267.56187 | 2097668.72921 | 37.740711974479 | -122.386311362403 | (37.740711974479, -122.386311362403) | 10 | 3 | 8 | 58 | 1 | |||
146 | 190658 | DPW Maintained 1 | :: 45 | 1461 Fairfax Ave | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6016241.73559 | 2097685.48667 | 37.7407565574799 | -122.386401828788 | (37.7407565574799, -122.386401828788) | 10 | 3 | 8 | 58 | 1 | |||
191423 | 6842 | DPW Maintained 1 | :: 45 | 1461 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/27/2016 07:14:00 AM | 3 | 3X3 | 6016194.23735 | 2097718.16262 | 37.7408436496142 | -122.386568339179 | (37.7408436496142, -122.386568339179) | 10 | 3 | 8 | 58 | 1 | ||
47594 | 6841 | DPW Maintained 1 | :: 45 | 1461 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2007 12:00:00 AM | 6 | 3X3 | 6016176.35578 | 2097734.00436 | 37.7408861578704 | -122.386631271932 | (37.7408861578704, -122.386631271932) | 10 | 3 | 8 | 58 | 1 | ||
99412 | 200808 | DPW Maintained 1 | :: 45 | 1401 Oakdale Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6016065.8568 | 2094678.3259 | 37.7324897642599 | -122.386800296411 | (37.7324897642599, -122.386800296411) | 10 | 3 | 8 | 58 | 1 | |||
98467 | 200699 | DPW Maintained 1 | :: 45 | 1501 Lane St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6015860.7307 | 2095472.4329 | 37.7346588632003 | -122.387564854217 | (37.7346588632003, -122.387564854217) | 10 | 3 | 8 | 58 | 1 | |||
94232 | 200742 | DPW Maintained 1 | :: 45 | 1454 Oakdale Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6015834.4667 | 2094922.2745 | 37.7331467841736 | -122.387617287866 | (37.7331467841736, -122.387617287866) | 10 | 3 | 8 | 58 | 1 | |||
62362 | 200730 | DPW Maintained 1 | :: 45 | 1466 Oakdale Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6015770.4184 | 2094966.2292 | 37.73326392707 | -122.387841787924 | (37.73326392707, -122.387841787924) | 10 | 3 | 8 | 58 | 1 | |||
123816 | 200722 | DPW Maintained 1 | :: 45 | 1476 Oakdale Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6015747.1852 | 2094980.6714 | 37.7333022953684 | -122.387923119588 | (37.7333022953684, -122.387923119588) | 10 | 3 | 8 | 58 | 1 | |||
190604 | 200729 | DPW Maintained 1 | :: 45 | 1481 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6015678.7414 | 2094969.3688 | 37.7332674687178 | -122.388158962258 | (37.7332674687178, -122.388158962258) | 10 | 3 | 8 | 58 | 1 | |||
60026 | 40070 | Permitted Site 7 | :: 45 | 1434 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41296 | 6015644.04223078 | 2093317.32333735 | 37.7287293601115 | -122.388163675017 | (37.7287293601115, -122.388163675017) | 10 | 3 | 8 | 58 | 1 | ||
22783 | 200577 | DPW Maintained 1 | :: 45 | 1701 Keith St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6015592.5071 | 2093926.7262 | 37.7303998031535 | -122.388384353362 | (37.7303998031535, -122.388384353362) | 10 | 3 | 8 | 58 | 1 | |||
129771 | 253008 | DPW Maintained 1 | :: 45 | 1201 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/10/2017 12:00:00 AM | 3 | 11x477 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | ||
18457 | 107144 | DPW Maintained 1 | :: 45 | 360 Spear St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 02/12/2020 12:00:00 AM | 3 | 6015708 | 2115219 | 37.7888702311939 | -122.38947147438 | (37.7888702311939, -122.38947147438) | 6 | 2 | 9 | 28855 | 6 | |||
76602 | 200226 | DPW Maintained 1 | :: 45 | 1131 Fitzgerald Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6015013.4132 | 2090222.9153 | 37.7201977688326 | -122.390127728915 | (37.7201977688326, -122.390127728915) | 10 | 3 | 8 | 58 | 1 | |||
43706 | 200497 | DPW Maintained 1 | :: 45 | 1110 Gilman Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6014977.2953 | 2089975.1673 | 37.7195154981888 | -122.390235277748 | (37.7195154981888, -122.390235277748) | 10 | 3 | 8 | 58 | 1 | |||
31214 | 199649 | DPW Maintained 1 | :: 45 | 1601 Evans Ave | 22 | : | Tree | Private 2 | 0 | Width 1ft | 6015107.35337 | 2098882.19142 | 37.7439796026678 | -122.390407721252 | (37.7439796026678, -122.390407721252) | 10 | 3 | 8 | 58 | 1 | |||
18831 | 199650 | DPW Maintained 1 | :: 45 | 0 | 1 | : | Tree | Private 2 | 0 | Width 0ft | 6014963.58685 | 2093280.81794 | 37.7285913984524 | -122.390513521988 | (37.7285913984524, -122.390513521988) | 10 | 3 | 8 | 58 | 1 | |||
148127 | 200205 | DPW Maintained 1 | :: 45 | 1003 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014813.9755 | 2089679.7161 | 37.7186951869692 | -122.390779182777 | (37.7186951869692, -122.390779182777) | 10 | 3 | 8 | 58 | 1 | |||
69996 | 200194 | DPW Maintained 1 | :: 45 | 1011 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014781.1104 | 2089713.252 | 37.7187854464432 | -122.390895127615 | (37.7187854464432, -122.390895127615) | 10 | 3 | 8 | 58 | 1 | |||
119776 | 200234 | DPW Maintained 1 | :: 45 | 2895 Hawes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6014768.3667 | 2089489.9029 | 37.7181714665431 | -122.390923576462 | (37.7181714665431, -122.390923576462) | 10 | 3 | 8 | 58 | 1 | |||
75042 | 100252 | DPW Maintained 1 | :: 45 | 540 Delancey St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | 6015236.96681 | 2113599.67086 | 37.784397795653 | -122.390987973742 | (37.784397795653, -122.390987973742) | 6 | 2 | 9 | 28856 | 6 | |||
35874 | 200502 | DPW Maintained 1 | :: 45 | 1500 Armstrong Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6014797.5113 | 2092210.0981 | 37.7256422016088 | -122.391012853891 | (37.7256422016088, -122.391012853891) | 10 | 3 | 8 | 58 | 1 | |||
122628 | 200190 | DPW Maintained 1 | :: 45 | 1027 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014706.6607 | 2089771.6044 | 37.7189415394071 | -122.391156549139 | (37.7189415394071, -122.391156549139) | 10 | 3 | 8 | 58 | 1 | |||
9415 | 200180 | DPW Maintained 1 | :: 45 | 1031 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014690.5634 | 2089785.0188 | 37.7189774793874 | -122.391213128817 | (37.7189774793874, -122.391213128817) | 10 | 3 | 8 | 58 | 1 | |||
148781 | 46634 | Permitted Site 7 | :: 45 | 1569 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44755 | 6014739.1858404 | 2093576.72961431 | 37.7293914610682 | -122.391309972305 | (37.7293914610682, -122.391309972305) | 10 | 3 | 8 | 58 | 1 | ||
9942 | 200177 | DPW Maintained 1 | :: 45 | 1041 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014650.3204 | 2089811.8475 | 37.7190489123065 | -122.39135410876 | (37.7190489123065, -122.39135410876) | 10 | 3 | 8 | 58 | 1 | |||
119892 | 200501 | DPW Maintained 1 | :: 45 | 1550 Armstrong Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6014687.5837 | 2092287.487 | 37.7258485955534 | -122.391398275474 | (37.7258485955534, -122.391398275474) | 10 | 3 | 8 | 58 | 1 | |||
130912 | 200238 | DPW Maintained 1 | :: 45 | 917 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014595.9922 | 2089500.6344 | 37.7181913669776 | -122.391520156023 | (37.7181913669776, -122.391520156023) | 10 | 3 | 8 | 58 | 1 | |||
127369 | 200507 | DPW Maintained 1 | :: 45 | 1510 Carroll Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6014614.4494 | 2091644.4715 | 37.724078943993 | -122.391606161162 | (37.724078943993, -122.391606161162) | 10 | 3 | 8 | 58 | 1 | |||
191797 | 200172 | DPW Maintained 1 | :: 45 | 1053 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014576.5414 | 2089866.8464 | 37.7191958334242 | -122.391612979464 | (37.7191958334242, -122.391612979464) | 10 | 3 | 8 | 58 | 1 | |||
115260 | 200762 | DPW Maintained 1 | :: 45 | 1999 Lane St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6014632.1803 | 2093750.8421 | 37.7298635995705 | -122.391692072282 | (37.7298635995705, -122.391692072282) | 10 | 3 | 8 | 58 | 1 | |||
75061 | 200171 | DPW Maintained 1 | :: 45 | 1059 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014549.7127 | 2089886.9679 | 37.7192495938582 | -122.391707122944 | (37.7192495938582, -122.391707122944) | 10 | 3 | 8 | 58 | 1 | |||
100708 | 200169 | DPW Maintained 1 | :: 45 | 1061 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014525.5668 | 2089911.1138 | 37.7193145533562 | -122.391792274296 | (37.7193145533562, -122.391792274296) | 10 | 3 | 8 | 58 | 1 | |||
118244 | 200165 | DPW Maintained 1 | :: 45 | 1071 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014485.3238 | 2089939.2839 | 37.7193896687982 | -122.391933349185 | (37.7193896687982, -122.391933349185) | 10 | 3 | 8 | 58 | 1 | |||
95954 | 200161 | DPW Maintained 1 | :: 45 | 1083 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014425.6299 | 2089982.8806 | 37.7195060625081 | -122.392142737787 | (37.7195060625081, -122.392142737787) | 10 | 3 | 8 | 58 | 1 | |||
157514 | 200157 | DPW Maintained 1 | :: 45 | 1091 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014392.094 | 2090006.3557 | 37.7195686584119 | -122.392260301004 | (37.7195686584119, -122.392260301004) | 10 | 3 | 8 | 58 | 1 | |||
143855 | 200204 | DPW Maintained 1 | :: 45 | 2 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014372.6432 | 2089670.326 | 37.7186449071271 | -122.392304046142 | (37.7186449071271, -122.392304046142) | 10 | 3 | 8 | 58 | 1 | |||
50825 | 200155 | DPW Maintained 1 | :: 45 | 1091 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014363.9238 | 2090021.1115 | 37.7196076106807 | -122.392358707449 | (37.7196076106807, -122.392358707449) | 10 | 3 | 8 | 58 | 1 | |||
107754 | 200193 | DPW Maintained 1 | :: 45 | 975 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014303.5592 | 2089724.6542 | 37.7187902452961 | -122.392546641558 | (37.7187902452961, -122.392546641558) | 10 | 3 | 8 | 58 | 1 | |||
66506 | 200248 | DPW Maintained 1 | :: 45 | 1107 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014274.7183 | 2090092.8783 | 37.7197997141545 | -122.392672078819 | (37.7197997141545, -122.392672078819) | 10 | 3 | 8 | 58 | 1 | |||
12451 | 200191 | DPW Maintained 1 | :: 45 | 981 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014255.2675 | 2089757.5194 | 37.7188778046353 | -122.392715865878 | (37.7188778046353, -122.392715865878) | 10 | 3 | 8 | 58 | 1 | |||
125844 | 200178 | DPW Maintained 1 | :: 45 | 3201 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014218.378 | 2089782.3359 | 37.7189438969212 | -122.39284511455 | (37.7189438969212, -122.39284511455) | 10 | 3 | 8 | 58 | 1 | |||
188054 | 35462 | DPW Maintained 1 | :: 45 | 1016 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | 6 | Permit Number 38885 | 6014468.80099 | 2102427.52316 | 37.7536788925865 | -122.392863694223 | (37.7536788925865, -122.392863694223) | 10 | 3 | 8 | 28856 | 29 | |
115629 | 200244 | DPW Maintained 1 | :: 45 | 1123 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014193.5615 | 2090152.5722 | 37.7199591140845 | -122.392956785762 | (37.7199591140845, -122.392956785762) | 10 | 3 | 8 | 58 | 1 | |||
128848 | 200239 | DPW Maintained 1 | :: 45 | 1131 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014148.6234 | 2090188.791 | 37.7200560674381 | -122.393114655414 | (37.7200560674381, -122.393114655414) | 10 | 3 | 8 | 58 | 1 | |||
192580 | 200170 | DPW Maintained 1 | :: 45 | 1001 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014099.661 | 2089867.5171 | 37.7191711929066 | -122.393261433304 | (37.7191711929066, -122.393261433304) | 10 | 3 | 8 | 58 | 1 | |||
16374 | 200211 | DPW Maintained 1 | :: 45 | 974 Jamestown Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6014078.3317 | 2089599.897 | 37.7184351760665 | -122.39331644356 | (37.7184351760665, -122.39331644356) | 10 | 3 | 8 | 58 | 1 | |||
103836 | 200167 | DPW Maintained 1 | :: 45 | 1019 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014049.3571 | 2089910.443 | 37.7192862641022 | -122.393438318502 | (37.7192862641022, -122.393438318502) | 10 | 3 | 8 | 58 | 1 | |||
77012 | 200166 | DPW Maintained 1 | :: 45 | 1023 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014031.9185 | 2089919.1624 | 37.7193092369184 | -122.393499207549 | (37.7193092369184, -122.393499207549) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );