trees
2,694 rows where qSpecies_id = 84 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
884 | 261406 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
3071 | 31851 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1117 Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35299 | |||||||||||||
4023 | 31850 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
4740 | 119761 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
4940 | 39332 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
5244 | 261407 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
6169 | 39333 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
7788 | 39331 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
8270 | 261411 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
8717 | 119762 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
8992 | 261405 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
10081 | 119760 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
11366 | 53918 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
12262 | 261408 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
14089 | 261410 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
14566 | 31845 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
15267 | 119759 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
15516 | 39334 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
16965 | 31849 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
17187 | 261409 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
18369 | 261412 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
19387 | 31852 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1117 Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35299 | |||||||||||||
282 | 119806 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 251X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005545 | 2110174 | 37.7744491774234 | -122.424275134654 | (37.7744491774234, -122.424275134654) | 7 | 9 | 11 | 28852 | 10 | ||||
340 | 42995 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 436 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42871 | 6004515.16540478 | 2110012.02065503 | 37.7739462176361 | -122.42782598565 | (37.7739462176361, -122.42782598565) | 7 | 9 | 11 | 28852 | 10 | ||
4437 | 244983 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 299 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781995 | 6005200.9141 | 2109719.1317 | 37.7731807843789 | -122.425433016756 | (37.7731807843789, -122.425433016756) | 7 | 9 | 11 | 28852 | 10 | |
6160 | 42787 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 413 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 3x3 | Permit Number 42754 | 6004586.33786017 | 2109969.42501453 | 37.7738332863504 | -122.427576752843 | (37.7738332863504, -122.427576752843) | 7 | 9 | 11 | 28852 | 10 | |
9471 | 119842 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 350 Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
9852 | 31300 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 519 Birch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 10 | Permit Number 34943 | 6005263.3007 | 2111469.3023 | 37.7779898515936 | -122.425341782234 | (37.7779898515936, -122.425341782234) | 7 | 9 | 11 | 28852 | 10 | |
11452 | 110549 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
13210 | 244980 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 289 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005226.4402 | 2109722.7783 | 37.7731922392405 | -122.425344978098 | (37.7731922392405, -122.425344978098) | 7 | 9 | 11 | 28852 | 10 | |||
20713 | 107753 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 400X Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 7 | 9 | 11 | 28852 | 10 | ||||
21018 | 110553 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
23723 | 30734 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 281 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34629 | 6005251.19976575 | 2109714.98569866 | 37.7731722414546 | -122.425258776803 | (37.7731722414546, -122.425258776803) | 7 | 9 | 11 | 28852 | 10 | ||
23975 | 142257 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 541 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004803.1693 | 2110709.0411 | 37.7758763538472 | -122.426879382419 | (37.7758763538472, -122.426879382419) | 7 | 9 | 11 | 28852 | 10 | |||
27494 | 109159 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 200 Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | ||||
27984 | 138926 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 431 OCTAVIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005464.9166 | 2110768.0336 | 37.7760757272062 | -122.424594423557 | (37.7760757272062, -122.424594423557) | 7 | 9 | 11 | 28852 | 10 | |||
28153 | 244988 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 260 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2018 12:00:00 AM | 3 | Width 0ft | 6005214.8927 | 2109749.52 | 37.7732650130646 | -122.425386825853 | (37.7732650130646, -122.425386825853) | 7 | 9 | 11 | 28852 | 10 | ||
28839 | 119865 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451X Octavia St Frontage West | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
28979 | 110554 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
29442 | 42763 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 415 Buchanan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.427511197042 | (37.7737647507648, -122.427511197042) | 7 | 9 | 11 | 28852 | 10 | |||
29717 | 107752 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400X Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x3 | Permit Number 772924 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 7 | 9 | 11 | 28852 | 10 | |||
30425 | 142001 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 762 FULTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004249.2696 | 2111539.4607 | 37.7781251474871 | -122.428854679323 | (37.7781251474871, -122.428854679323) | 7 | 9 | 11 | 28852 | 41 | |||
31012 | 42789 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 426 -28 -30 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 3x3 | Permit Number 42755 | 6004546 | 2110000 | 37.7739149561089 | -122.427718466962 | (37.7739149561089, -122.427718466962) | 7 | 9 | 11 | 28852 | 10 | ||
31843 | 119859 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 431 Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
33066 | 42783 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 202 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42751 | 6005176.07009417 | 2109735.98338901 | 37.7732256513259 | -122.425520155041 | (37.7732256513259, -122.425520155041) | 7 | 9 | 11 | 28852 | 10 | ||
33346 | 245221 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 341 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005088.7556 | 2110037.9678 | 37.7740498933785 | -122.425843687227 | (37.7740498933785, -122.425843687227) | 7 | 9 | 11 | 28852 | 10 | |||
36097 | 115453 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 300 Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
38409 | 110550 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
38617 | 119866 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451X Octavia St Frontage West | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
39487 | 244972 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 209 Rose St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005534.5777 | 2109768.9686 | 37.7733364706745 | -122.424282374507 | (37.7733364706745, -122.424282374507) | 7 | 9 | 11 | 28852 | 10 | |||
40216 | 244239 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 253 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005546.7389 | 2110177.0116 | 37.7744575447356 | -122.424269333697 | (37.7744575447356, -122.424269333697) | 7 | 9 | 11 | 28852 | 10 | |||
42803 | 115684 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100x Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005589 | 2109665 | 37.7730540708525 | -122.424086724818 | (37.7730540708525, -122.424086724818) | 7 | 9 | 11 | 28852 | 10 | ||||
43629 | 119810 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 250 Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | ||||
44073 | 142255 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 521 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004876.8784 | 2110720.6117 | 37.7759122912727 | -122.426625227687 | (37.7759122912727, -122.426625227687) | 7 | 9 | 11 | 28852 | 10 | |||
44178 | 103651 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 307X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |
45122 | 87992 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 230 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51030 | 6008092 | 2113193 | 37.7828821185058 | -122.41567835443 | (37.7828821185058, -122.41567835443) | 7 | 10 | 9 | 28852 | 36 | ||
46174 | 244365 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 301 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005511.8056 | 2110439.7613 | 37.7751770191286 | -122.424408867351 | (37.7751770191286, -122.424408867351) | 7 | 9 | 11 | 28852 | 10 | |||
48105 | 142263 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 585 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004612.4683 | 2110683.7571 | 37.7757961457109 | -122.427537264685 | (37.7757961457109, -122.427537264685) | 7 | 9 | 11 | 28852 | 10 | |||
48774 | 119805 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 251X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005545 | 2110174 | 37.7744491774234 | -122.424275134654 | (37.7744491774234, -122.424275134654) | 7 | 9 | 11 | 28852 | 10 | ||||
49694 | 119841 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 350 Octavia St Frontage East | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
51800 | 91186 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 291 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 2 | 6x9 | Permit Number 52039 | 6005173 | 2109884 | 37.7736318955877 | -122.425541311156 | (37.7736318955877, -122.425541311156) | 7 | 9 | 11 | 28852 | 10 | |
52301 | 107755 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 400X Lily St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 7 | 9 | 11 | 28852 | 10 | |||||
52758 | 47013 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 445 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2004 12:00:00 AM | Permit Number 47268 | 6004844.28922352 | 2110353.57072253 | 37.7749026438811 | -122.426711818296 | (37.7749026438811, -122.426711818296) | 7 | 9 | 11 | 28852 | 10 | ||
54224 | 119853 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 401 Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
54663 | 110552 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
55324 | 138925 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 431 OCTAVIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005461.4768 | 2110789.2454 | 37.7761337753876 | -122.424607831994 | (37.7761337753876, -122.424607831994) | 7 | 9 | 11 | 28852 | 10 | |||
55977 | 119812 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 250 Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | ||||
56426 | 244956 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 298 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6005155.9394 | 2109820.0209 | 37.77345526051 | -122.42559577205 | (37.77345526051, -122.42559577205) | 7 | 9 | 11 | 28852 | 10 | |||
58002 | 119858 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 431 Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
58451 | 110547 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
58652 | 31299 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 519 Birch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 8 | Permit Number 34943 | 6005251.2106 | 2111468.7266 | 37.777987587802 | -122.425383565241 | (37.777987587802, -122.425383565241) | 7 | 9 | 11 | 28852 | 10 | |
60687 | 42765 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 415 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.427511197042 | (37.7737647507648, -122.427511197042) | 7 | 9 | 11 | 28852 | 10 | |||
61525 | 46331 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 201 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/2002 12:00:00 AM | Permit Number 44582 | 6005568.06039934 | 2110039.04677053 | 37.7740799306106 | -122.424185764506 | (37.7740799306106, -122.424185764506) | 7 | 9 | 11 | 28852 | 10 | ||
61618 | 244350 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 300 Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2017 07:22:00 AM | 3 | Width 0ft | 6005619.219 | 2110418.7508 | 37.7751253943864 | -122.424035805431 | (37.7751253943864, -122.424035805431) | 7 | 9 | 11 | 28852 | 10 | ||
61621 | 8104 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 780 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004088.9733 | 2111516.0342 | 37.7780517500412 | -122.429407531137 | (37.7780517500412, -122.429407531137) | 7 | 9 | 11 | 28852 | 41 | ||
64335 | 138975 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 461 Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005450.5842 | 2110864.9202 | 37.7763409448097 | -122.42465089693 | (37.7763409448097, -122.42465089693) | 7 | 9 | 11 | 28852 | 10 | |||
65404 | 46332 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 201 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/2002 12:00:00 AM | Permit Number 44582 | 6005568.06039934 | 2110039.04677053 | 37.7740799306106 | -122.424185764506 | (37.7740799306106, -122.424185764506) | 7 | 9 | 11 | 28852 | 10 | ||
68060 | 31301 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 529 Birch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 8 | Permit Number 34944 | 6005236.8177 | 2111465.8481 | 37.7779788709631 | -122.425433150534 | (37.7779788709631, -122.425433150534) | 7 | 9 | 11 | 28852 | 10 | |
68068 | 44186 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 792 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2002 12:00:00 AM | 5 | 3x3 | Permit Number 45643 | 6004083.1428 | 2110821.1912 | 37.7761435523821 | -122.429378138275 | (37.7761435523821, -122.429378138275) | 7 | 9 | 11 | 28852 | 10 |
69433 | 107757 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 400X Lily St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 7 | 9 | 11 | 28852 | 10 | |||||
70233 | 139392 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 466 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005058.4753 | 2111113.4947 | 37.7770013168736 | -122.426025011181 | (37.7770013168736, -122.426025011181) | 7 | 9 | 11 | 28852 | 10 | |||
70239 | 142454 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 537 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004825.882 | 2110712.4694 | 37.7758870513166 | -122.426801057519 | (37.7758870513166, -122.426801057519) | 7 | 9 | 11 | 28852 | 10 | |||
70643 | 244389 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 250 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005653.9696 | 2110171.6272 | 37.7744488147211 | -122.42389801886 | (37.7744488147211, -122.42389801886) | 7 | 9 | 11 | 28852 | 10 | |||
70667 | 115688 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 150X Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005692.21728 | 2109889.45005 | 37.7736761836422 | -122.423745644927 | (37.7736761836422, -122.423745644927) | 7 | 9 | 11 | 28852 | 10 | ||||
71027 | 43003 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 205X Rose St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | 7 | 9 | 11 | 28852 | 10 | |||
71162 | 256523 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 260 Rose St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6005231.3024 | 2109750.7356 | 37.7732692779132 | -122.425330148953 | (37.7732692779132, -122.425330148953) | 7 | 9 | 11 | 28852 | 10 | ||||
71737 | 138874 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 OCTAVIA ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005562.0898 | 2110802.7178 | 37.7761764489655 | -122.424260742604 | (37.7761764489655, -122.424260742604) | 7 | 9 | 11 | 28852 | 10 | |||
71882 | 244992 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 249 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005441.5895 | 2109754.3822 | 37.7732911688522 | -122.424602996105 | (37.7732911688522, -122.424602996105) | 7 | 9 | 11 | 28852 | 10 | |||
72864 | 244352 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 300 Octavia St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005613.5532 | 2110456.5225 | 37.7752287864343 | -122.424058091407 | (37.7752287864343, -122.424058091407) | 7 | 9 | 11 | 28852 | 10 | |||
72883 | 30735 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 281 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 6 | Permit Number 34629 | 6005260 | 2109713 | 37.7731672863676 | -122.42522819429 | (37.7731672863676, -122.42522819429) | 7 | 9 | 11 | 28852 | 10 | |
73713 | 244366 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 301 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005514.1663 | 2110403.406 | 37.7750773296011 | -122.424398114747 | (37.7750773296011, -122.424398114747) | 7 | 9 | 11 | 28852 | 10 | |||
74267 | 31302 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 529 Birch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 9 | Permit Number 34944 | 6005223.0006 | 2111465.2723 | 37.7779765092875 | -122.425480907835 | (37.7779765092875, -122.425480907835) | 7 | 9 | 11 | 28852 | 10 | |
74848 | 139395 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 486 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005025.4278 | 2111110.8954 | 37.7769923120329 | -122.426139147688 | (37.7769923120329, -122.426139147688) | 7 | 9 | 11 | 28852 | 10 | |||
74948 | 42761 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 415 Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.427511197042 | (37.7737647507648, -122.427511197042) | 7 | 9 | 11 | 28852 | 10 | |||
75128 | 244991 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 213 Lily St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005531.8427 | 2110116.9147 | 37.7742916920696 | -122.424316587333 | (37.7742916920696, -122.424316587333) | 7 | 9 | 11 | 28852 | 10 | |||
75976 | 119596 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 431 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005470 | 2110737 | 37.7759908035691 | -122.42457463067 | (37.7759908035691, -122.42457463067) | 7 | 9 | 11 | 28852 | 10 | ||||
76471 | 244994 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 231 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | 4 | Width 0ft | Permit Number 45013 | 6005396.3109 | 2110099.8972 | 37.7742373121563 | -122.4247842062 | (37.7742373121563, -122.4247842062) | 7 | 9 | 11 | 28852 | 10 | |
77446 | 119877 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 450X Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
77588 | 42997 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 438 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42872 | 6004509.83171755 | 2110011.27832833 | 37.7739438776611 | -122.427844382866 | (37.7739438776611, -122.427844382866) | 7 | 9 | 11 | 28852 | 10 | ||
78073 | 33620 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 426 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/1999 12:00:00 AM | Permit Number 37725 | 6004541.83388077 | 2110015.73229407 | 37.7739579174854 | -122.427733999418 | (37.7739579174854, -122.427733999418) | 7 | 9 | 11 | 28852 | 10 |
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) );