trees
3,587 rows where qSpecies_id = 28 sorted by TreeID descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
60177 | 99996 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
169008 | 99995 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Permit Number 44594 | 6011799.65117 | 2117580.00293 | 37.795135512042 | -122.403160044009 | (37.795135512042, -122.403160044009) | 3 | 1 | 10 | 28860 | 4 | |||
175597 | 99994 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
84637 | 99993 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
179677 | 99992 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
5844 | 99991 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
148277 | 99990 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Permit Number 44594 | 6011811.05033 | 2117521.86685 | 37.7949765208901 | -122.403116509626 | (37.7949765208901, -122.403116509626) | 3 | 1 | 10 | 28860 | 4 | |||
189935 | 99989 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Permit Number 44594 | 6011816.52839 | 2117490.26365 | 37.7948900519939 | -122.403095330591 | (37.7948900519939, -122.403095330591) | 3 | 1 | 10 | 28860 | 4 | |||
167930 | 99988 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
20003 | 99987 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 535@Clay Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012018 | 2117734 | 37.7955705425922 | -122.402415352518 | (37.7955705425922, -122.402415352518) | 3 | 1 | 10 | 28860 | 4 | |||||
128468 | 99971 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2270 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
9226 | 99970 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2270 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
48096 | 99968 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2270 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
20880 | 99966 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2270 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
134287 | 99878 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 261 Laurel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 6x8 | 5998035.65095 | 2115667.71588 | 37.7891066027242 | -122.450647442448 | (37.7891066027242, -122.450647442448) | 11 | 6 | 1 | 54 | 31 | |||
39482 | 99877 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 261 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6x9 | 5998033.46832 | 2115684.09977 | 37.789151463605 | -122.450656175749 | (37.789151463605, -122.450656175749) | 11 | 6 | 1 | 54 | 31 | |||
66269 | 99611 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 Entrada Ct | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992743 | 2092489 | 37.7251595224946 | -122.467273147781 | (37.7251595224946, -122.467273147781) | 9 | 8 | 4 | 59 | 40 | |||||
25604 | 99496 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Plymouth Ave | 3 | Median : Cutout | Tree | Private 2 | 5995903 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | 9 | 7 | 4 | 28861 | 40 | |||||
153994 | 99495 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Plymouth Ave | 2 | Median : Cutout | Tree | Private 2 | 5995903 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | 9 | 7 | 4 | 28861 | 40 | |||||
64138 | 99494 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Plymouth Ave | 1 | Median : Cutout | Tree | Private 2 | 5995903 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | 9 | 7 | 4 | 28861 | 40 | |||||
31197 | 99493 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Miramar Ave | 3 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | 9 | 7 | 4 | 28861 | 40 | |||
171542 | 99492 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Miramar Ave | 2 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | 9 | 7 | 4 | 28861 | 40 | |||
59487 | 99491 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Miramar Ave | 5 | Median : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | 9 | 7 | 4 | 28861 | 40 | |
100839 | 99490 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Miramar Ave | 4 | Median : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | 9 | 7 | 4 | 28861 | 40 | |
9937 | 99488 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Miramar Ave | 1 | Median : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | 9 | 7 | 4 | 28861 | 40 | |
1111 | 99485 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Miramar Ave | 6 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | 9 | 7 | 4 | 28861 | 40 | |||
161162 | 99484 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Miramar Ave | 5 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | 9 | 7 | 4 | 28861 | 40 | |||
32678 | 99483 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Miramar Ave | 2 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | 9 | 7 | 4 | 28861 | 40 | |||
188566 | 99482 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Miramar Ave | 1 | Median : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | 9 | 7 | 4 | 28861 | 40 | |
106199 | 99481 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 650X Miramar Ave | 3 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.458085302932 | (37.728535605791, -122.458085302932) | 9 | 7 | 4 | 28861 | 40 | |||
11098 | 99478 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 650X Miramar Ave | 4 | Median : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.458085302932 | (37.728535605791, -122.458085302932) | 9 | 7 | 4 | 28861 | 40 | |
97346 | 99476 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 650X Miramar Ave | 2 | Median : Cutout | Tree | Private 2 | 10/28/2014 12:00:00 AM | 3 | 15x280 | Permit Number 772553 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.458085302932 | (37.728535605791, -122.458085302932) | 9 | 7 | 4 | 28861 | 40 | |
35906 | 99475 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 650X Miramar Ave | 1 | Median : Cutout | Tree | Private 2 | 04/18/2014 12:00:00 AM | 44 | 15x280 | Permit Number 772553 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.458085302932 | (37.728535605791, -122.458085302932) | 9 | 7 | 4 | 28861 | 40 | |
57898 | 99471 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Miramar Ave | 7 | Median : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995435.2 | 2093399 | 37.7278132105567 | -122.458032376835 | (37.7278132105567, -122.458032376835) | 9 | 7 | 4 | 28861 | 40 | |
100131 | 99470 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Miramar Ave | 8 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995435.2 | 2093399 | 37.7278132105567 | -122.458032376835 | (37.7278132105567, -122.458032376835) | 9 | 7 | 4 | 28861 | 40 | |||
82305 | 99469 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Miramar Ave | 6 | Median : Cutout | Tree | Private 2 | 4 | 15x280 | 5995435.2 | 2093399 | 37.7278132105567 | -122.458032376835 | (37.7278132105567, -122.458032376835) | 9 | 7 | 4 | 28861 | 40 | |||
13816 | 99468 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Miramar Ave | 4 | Median : Cutout | Tree | Private 2 | 6 | 15x280 | 5995435.2 | 2093399 | 37.7278132105567 | -122.458032376835 | (37.7278132105567, -122.458032376835) | 9 | 7 | 4 | 28861 | 40 | |||
173522 | 99467 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Miramar Ave | 3 | Median : Cutout | Tree | Private 2 | 6 | 15x280 | 5995435.2 | 2093399 | 37.7278132105567 | -122.458032376835 | (37.7278132105567, -122.458032376835) | 9 | 7 | 4 | 28861 | 40 | |||
78448 | 99466 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Miramar Ave | 1 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995435.2 | 2093399 | 37.7278132105567 | -122.458032376835 | (37.7278132105567, -122.458032376835) | 9 | 7 | 4 | 28861 | 40 | |||
47231 | 99464 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 550X Miramar Ave | 9 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995413 | 2092983.7 | 37.7266716211667 | -122.458079078858 | (37.7266716211667, -122.458079078858) | 9 | 7 | 4 | 28861 | 40 | |||
67361 | 99463 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 550X Miramar Ave | 6 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995413 | 2092983.7 | 37.7266716211667 | -122.458079078858 | (37.7266716211667, -122.458079078858) | 9 | 7 | 4 | 28861 | 40 | |||
132340 | 99462 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 550X Miramar Ave | 2 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995413 | 2092983.7 | 37.7266716211667 | -122.458079078858 | (37.7266716211667, -122.458079078858) | 9 | 7 | 4 | 28861 | 40 | |||
57864 | 99459 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 550X Miramar Ave | 5 | Median : Cutout | Tree | Private 2 | 10/28/2014 12:00:00 AM | 3 | 15x280 | Permit Number 772553 | 5995413 | 2092983.7 | 37.7266716211667 | -122.458079078858 | (37.7266716211667, -122.458079078858) | 9 | 7 | 4 | 28861 | 40 | |
47424 | 99456 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 400X Miramar Ave | 6 | Median : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995388.7 | 2092398.7 | 37.7250639553871 | -122.458120762721 | (37.7250639553871, -122.458120762721) | 9 | 7 | 4 | 28861 | 40 | |
155211 | 99453 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 400X Miramar Ave | 3 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995388.7 | 2092398.7 | 37.7250639553871 | -122.458120762721 | (37.7250639553871, -122.458120762721) | 9 | 7 | 4 | 28861 | 40 | |||
60005 | 99452 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 400X Miramar Ave | 2 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995388.7 | 2092398.7 | 37.7250639553871 | -122.458120762721 | (37.7250639553871, -122.458120762721) | 9 | 7 | 4 | 28861 | 40 | |||
24143 | 99344 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 22 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986571.83486 | 2113111.88593 | 37.7814261792312 | -122.490122179259 | (37.7814261792312, -122.490122179259) | 11 | 6 | 2 | 55 | 26 | ||
127692 | 99342 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 20 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986574.23671 | 2113063.60704 | 37.7812937594666 | -122.490110317893 | (37.7812937594666, -122.490110317893) | 11 | 6 | 2 | 55 | 26 | ||
57556 | 99341 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 19 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 24 | 4x5 | 5986573.71046 | 2113038.86406 | 37.7812257915862 | -122.49011031791 | (37.7812257915862, -122.49011031791) | 11 | 6 | 2 | 55 | 26 | ||
90721 | 99340 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 18 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 30 | 6x8 | 5986575.04866 | 2113011.09375 | 37.7811496204005 | -122.490103645203 | (37.7811496204005, -122.490103645203) | 11 | 6 | 2 | 55 | 26 | ||
84709 | 99338 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3X3 | 5986576.26956 | 2112967.74794 | 37.7810306764919 | -122.490096232309 | (37.7810306764919, -122.490096232309) | 11 | 6 | 2 | 55 | 26 | ||
64192 | 99336 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986577.60051 | 2112919.49158 | 37.7808982560395 | -122.490088077428 | (37.7808982560395, -122.490088077428) | 11 | 6 | 2 | 55 | 26 | ||
123461 | 99334 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 5986579.77919 | 2112870.79018 | 37.7807646631349 | -122.490076957163 | (37.7807646631349, -122.490076957163) | 11 | 6 | 2 | 55 | 26 | ||
134772 | 99209 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 Hahn St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768718 | 6007772.4 | 2088271.5 | 37.7144353163031 | -122.415019520784 | (37.7144353163031, -122.415019520784) | 9 | 7 | 8 | 309 | 39 | ||||
52388 | 99208 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 Hahn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768718 | 6007772.4 | 2088271.5 | 37.7144353163031 | -122.415019520784 | (37.7144353163031, -122.415019520784) | 9 | 7 | 8 | 309 | 39 | ||||
159729 | 99173 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2100 Webster St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 25928 | 6003311.25259 | 2116120.54401 | 37.790650512059 | -122.432426898975 | (37.790650512059, -122.432426898975) | 13 | 9 | 1 | 29490 | 27 | ||
38501 | 99172 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2100 Webster St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 25928 | 6003312.12208 | 2116110.60344 | 37.7906232670935 | -122.432423180296 | (37.7906232670935, -122.432423180296) | 13 | 9 | 1 | 29490 | 27 | ||
189469 | 99171 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2100 Webster St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 25928 | 6003316.34975 | 2116092.54276 | 37.7905739167998 | -122.432407262311 | (37.7905739167998, -122.432407262311) | 13 | 9 | 1 | 29490 | 27 | ||
167051 | 99170 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2100 Webster St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 25928 | 6003318.49866 | 2116076.63924 | 37.7905303716413 | -122.432398690859 | (37.7905303716413, -122.432398690859) | 13 | 9 | 1 | 29490 | 27 | ||
122135 | 99169 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2100 Webster St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 25928 | 6003320.5239 | 2116054.74736 | 37.7904703769598 | -122.432390119424 | (37.7904703769598, -122.432390119424) | 13 | 9 | 1 | 29490 | 27 | ||
99561 | 99168 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2100 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 25928 | 6003328.674 | 2116003.83043 | 37.7903310341863 | -122.432358282529 | (37.7903310341863, -122.432358282529) | 13 | 9 | 1 | 29490 | 27 | ||
144638 | 99167 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2100 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 25928 | 6003331.11107 | 2115984.74946 | 37.7902787808939 | -122.432348487091 | (37.7902787808939, -122.432348487091) | 13 | 9 | 1 | 29490 | 27 | ||
93339 | 99166 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2100 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | Permit Number 25928 | 6003335.03609 | 2115969.16201 | 37.7902362042855 | -122.432333793087 | (37.7902362042855, -122.432333793087) | 13 | 9 | 1 | 29490 | 27 | ||
163030 | 99119 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 480 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 3x3 | 6011162.75623 | 2119015.64779 | 37.799041856745 | -122.405464967752 | (37.799041856745, -122.405464967752) | 3 | 1 | 10 | 308 | 23 | |||
66003 | 99092 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2801@Broderick Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000146.4 | 2117058.8 | 37.7930467467367 | -122.443444504836 | (37.7930467467367, -122.443444504836) | 13 | 6 | 1 | 29490 | 27 | ||||
180209 | 99091 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2801@Broderick Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000146.4 | 2117058.8 | 37.7930467467367 | -122.443444504836 | (37.7930467467367, -122.443444504836) | 13 | 6 | 1 | 29490 | 27 | ||||
49686 | 99089 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2801@Broderick Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000146.4 | 2117058.8 | 37.7930467467367 | -122.443444504836 | (37.7930467467367, -122.443444504836) | 13 | 6 | 1 | 29490 | 27 | ||||
144934 | 99088 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2801@Broderick Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 3x3 | 6000168.08867 | 2117087.82298 | 37.7931276730419 | -122.443371546666 | (37.7931276730419, -122.443371546666) | 13 | 9 | 1 | 29490 | 27 | |||
160712 | 99087 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2801@Broderick Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000146.4 | 2117058.8 | 37.7930467467367 | -122.443444504836 | (37.7930467467367, -122.443444504836) | 13 | 6 | 1 | 29490 | 27 | ||||
66059 | 99085 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2801 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6000131.22442 | 2117083.23739 | 37.7931129799394 | -122.443498769248 | (37.7931129799394, -122.443498769248) | 13 | 9 | 1 | 29490 | 27 | |||
156113 | 99084 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2801 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000146.4 | 2117058.8 | 37.7930467467367 | -122.443444504836 | (37.7930467467367, -122.443444504836) | 13 | 6 | 1 | 29490 | 27 | ||||
105861 | 99052 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 690 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | 4x7 | 5991960.5264 | 2110747.51033 | 37.7752474613438 | -122.471307771412 | (37.7752474613438, -122.471307771412) | 11 | 6 | 2 | 54 | 11 | |||
145579 | 99013 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 125x Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006331.3 | 2098231.1 | 37.7417011178952 | -122.420707158841 | (37.7417011178952, -122.420707158841) | 2 | 7 | 7 | 28859 | 2 | ||||
134599 | 99012 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 125x Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2012 12:00:00 AM | 3x3 | 6006331.3 | 2098231.1 | 37.7417011178952 | -122.420707158841 | (37.7417011178952, -122.420707158841) | 2 | 7 | 7 | 28859 | 2 | |||
114321 | 98926 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3541 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x4 | 5997927.34517 | 2115124.96878 | 37.7876101632223 | -122.450983011859 | (37.7876101632223, -122.450983011859) | 11 | 6 | 1 | 54 | 31 | |||
172722 | 98925 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3541 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4x4 | 5997905.152 | 2115121.83421 | 37.7876002859601 | -122.451059569364 | (37.7876002859601, -122.451059569364) | 11 | 6 | 1 | 54 | 31 | |||
85087 | 98924 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3527 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 5997977.38318 | 2115131.5705 | 37.7876311543002 | -122.4508103672 | (37.7876311543002, -122.4508103672) | 11 | 6 | 1 | 54 | 31 | |||
3684 | 98923 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3527 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 5997962.31773 | 2115134.58282 | 37.7876385629149 | -122.450862707746 | (37.7876385629149, -122.450862707746) | 11 | 6 | 1 | 54 | 31 | |||
71042 | 98705 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1050 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2012 12:00:00 AM | 10 | 3x3 | Permit Number 768656 | 6007880.11955 | 2092984.06974 | 37.7273810881671 | -122.414980548629 | (37.7273810881671, -122.414980548629) | 9 | 3 | 7 | 309 | 5 | |
45859 | 98551 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 290X Brighton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x5.5 | 5996260 | 2091802.8 | 37.7234777811703 | -122.45506574959 | (37.7234777811703, -122.45506574959) | 9 | 8 | 4 | 28861 | 24 | ||||
63569 | 98550 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 290X Brighton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5.5x5.5 | 5996260 | 2091802.8 | 37.7234777811703 | -122.45506574959 | (37.7234777811703, -122.45506574959) | 9 | 8 | 4 | 28861 | 24 | ||||
184107 | 98549 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 290X Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5.5x5.5 | 5996260 | 2091802.8 | 37.7234777811703 | -122.45506574959 | (37.7234777811703, -122.45506574959) | 9 | 8 | 4 | 28861 | 24 | ||||
19666 | 98539 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 710 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 4x4 | 5991968.21537 | 2110556.64654 | 37.774723845896 | -122.471267264576 | (37.774723845896, -122.471267264576) | 11 | 6 | 2 | 54 | 11 | |||
142643 | 98440 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2221 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6006778 | 2118835 | 37.7982997004911 | -122.420624895529 | (37.7982997004911, -122.420624895529) | 5 | 9 | 10 | 28858 | 32 | |||
148827 | 98439 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2221 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6006778 | 2118835 | 37.7982997004911 | -122.420624895529 | (37.7982997004911, -122.420624895529) | 5 | 9 | 10 | 28858 | 32 | |||
144593 | 98438 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2221 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6006778 | 2118835 | 37.7982997004911 | -122.420624895529 | (37.7982997004911, -122.420624895529) | 5 | 9 | 10 | 28858 | 32 | |||
188736 | 98324 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1899X Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3x3 | 6001966.9 | 2114999.4 | 37.7874958161075 | -122.4369979772 | (37.7874958161075, -122.4369979772) | 13 | 6 | 11 | 29490 | 27 | |||
81231 | 98322 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1899X Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001966.9 | 2114999.4 | 37.7874958161075 | -122.4369979772 | (37.7874958161075, -122.4369979772) | 13 | 6 | 11 | 29490 | 27 | ||||
190171 | 98321 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1899X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 48 | 3x3 | 6001966.9 | 2114999.4 | 37.7874958161075 | -122.4369979772 | (37.7874958161075, -122.4369979772) | 13 | 6 | 11 | 29490 | 27 | |||
60738 | 98320 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1811 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773893 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | 13 | 6 | 11 | 29490 | 27 | |
56537 | 98319 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1811 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | 13 | 6 | 11 | 29490 | 27 | ||||
115484 | 98079 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 731 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x12 | 6001992.2 | 2108216.2 | 37.7688722929253 | -122.436424775079 | (37.7688722929253, -122.436424775079) | 15 | 5 | 5 | 29492 | 3 | ||||
173395 | 98078 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 731 Duboce Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 6001992.2 | 2108216.2 | 37.7688722929253 | -122.436424775079 | (37.7688722929253, -122.436424775079) | 15 | 5 | 5 | 29492 | 3 | ||||
59115 | 98048 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2251 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6003429.10066 | 2116873.98532 | 37.7927259513035 | -122.432072977999 | (37.7927259513035, -122.432072977999) | 13 | 9 | 1 | 29490 | 27 | |||
41621 | 98047 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2251 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6003407.78151 | 2116869.84399 | 37.7927133715759 | -122.432146447219 | (37.7927133715759, -122.432146447219) | 13 | 9 | 1 | 29490 | 27 | |||
31529 | 97954 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 140 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | 3x3 | Permit Number 768198 | 5995938.36032 | 2113419.39672 | 37.7828130508284 | -122.457741003486 | (37.7828130508284, -122.457741003486) | 11 | 6 | 1 | 54 | 31 | ||
120106 | 97953 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 140 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5995940.16242 | 2113388.09903 | 37.7827272192418 | -122.457732503626 | (37.7827272192418, -122.457732503626) | 11 | 6 | 1 | 54 | 31 | |||
173612 | 97638 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1254 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 3x3 | 6008684 | 2117318 | 37.7942416273691 | -122.413922169868 | (37.7942416273691, -122.413922169868) | 5 | 1 | 10 | 28857 | 21 | |||
192988 | 97637 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1254 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008163 | 2117572 | 37.7949097746331 | -122.415742887246 | (37.7949097746331, -122.415742887246) | 5 | 1 | 10 | 28858 | 21 | |||||
181765 | 97636 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1254 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008163 | 2117572 | 37.7949097746331 | -122.415742887246 | (37.7949097746331, -122.415742887246) | 5 | 1 | 10 | 28858 | 21 |
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) );