trees
2,694 rows where qSpecies_id = 84 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17013 | 70667 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 20 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009828.97228 | 2111081.01172 | 37.7771805851524 | -122.409520022524 | (37.7771805851524, -122.409520022524) | 8 | 2 | 9 | 28853 | 34 | |||
17707 | 196376 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 135 Shipley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012181.96532 | 2112407.5214 | 37.7809544381487 | -122.40147347254 | (37.7809544381487, -122.40147347254) | 6 | 2 | 9 | 28856 | 34 | |||
20865 | 196378 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 135 Clara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6012410.67338 | 2112360.21924 | 37.7808373158188 | -122.400678929615 | (37.7808373158188, -122.400678929615) | 6 | 2 | 9 | 28856 | 34 | |||
21027 | 196418 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 74 Langton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010052.79507 | 2110841.75773 | 37.7765361885308 | -122.408728861943 | (37.7765361885308, -122.408728861943) | 8 | 2 | 9 | 28853 | 34 | |||
22463 | 196415 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 74 Langton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010031.16155 | 2110864.86545 | 37.7765984252192 | -122.408805329496 | (37.7765984252192, -122.408805329496) | 8 | 2 | 9 | 28853 | 34 | |||
22903 | 40229 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 101 South Park | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1999 12:00:00 AM | Permit Number 41410 | 6014331.14035058 | 2112607.2540326 | 37.7816225406641 | -122.394052345281 | (37.7816225406641, -122.394052345281) | 6 | 2 | 9 | 28856 | 6 | |||
23647 | 102209 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 89X Elgin Park | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | Permit Number 30082 | 6005852.4 | 2108559.9 | 37.7700345996314 | -122.423097025843 | (37.7700345996314, -122.423097025843) | 8 | 2 | 5 | 28853 | 19 | |
23943 | 91342 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 829 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2009 12:00:00 AM | 3x3 | Permit Number 52060 | 6012100 | 2112601 | 37.7814811117781 | -122.401770636493 | (37.7814811117781, -122.401770636493) | 6 | 2 | 9 | 28856 | 34 | ||
25804 | 196403 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 140 Langton St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6010340.69149 | 2110544.62696 | 37.7757364574022 | -122.407711985019 | (37.7757364574022, -122.407711985019) | 8 | 2 | 9 | 28853 | 34 | |||
27625 | 42210 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 937 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42479 | 6011834.2594701 | 2111457.32291808 | 37.7783260063796 | -122.402609526252 | (37.7783260063796, -122.402609526252) | 14 | 2 | 9 | 28856 | 34 | ||
28946 | 196423 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 5 Langton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6009782.26955 | 2111161.68642 | 37.7773994819478 | -122.409687278471 | (37.7773994819478, -122.409687278471) | 8 | 2 | 9 | 28853 | 34 | |||
32366 | 196377 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 137 Clara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012419.03852 | 2112368.2176 | 37.7808597440141 | -122.400650552379 | (37.7808597440141, -122.400650552379) | 6 | 2 | 9 | 28856 | 34 | |||
33075 | 67707 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 31 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | 11 | Permit Number 31318 | 6014113.95879 | 2113076.60421 | 37.7828991959845 | -122.39483657655 | (37.7828991959845, -122.39483657655) | 6 | 2 | 9 | 28856 | 6 | |
41243 | 196386 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 462 Stillman St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6013883.34247 | 2112854.56717 | 37.7822767077361 | -122.395618857241 | (37.7822767077361, -122.395618857241) | 6 | 2 | 9 | 28856 | 6 | |||
41313 | 196392 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 93 Stillman St | 4 | : | Tree | Private 2 | 1 | Width 3ft | 6013963.53714 | 2112927.48749 | 37.7824813907387 | -122.395346527235 | (37.7824813907387, -122.395346527235) | 6 | 2 | 9 | 28856 | 6 | |||
43932 | 196384 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 99 Stillman St | 3 | : | Tree | Private 2 | 7 | Width 0ft | 6013750.52811 | 2112736.60264 | 37.7819454154917 | -122.396070069587 | (37.7819454154917, -122.396070069587) | 6 | 2 | 9 | 28856 | 6 | |||
49618 | 91341 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 829 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2009 12:00:00 AM | 3x3 | Permit Number 52060 | 6012100 | 2112601 | 37.7814811117781 | -122.401770636493 | (37.7814811117781, -122.401770636493) | 6 | 2 | 9 | 28856 | 34 | ||
50499 | 196421 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 82 Langton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010097.25702 | 2110794.49543 | 37.776408907491 | -122.408571719809 | (37.776408907491, -122.408571719809) | 8 | 2 | 9 | 28853 | 34 | |||
52844 | 42211 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 937 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42479 | 6011834.2594701 | 2111457.32291808 | 37.7783260063796 | -122.402609526252 | (37.7783260063796, -122.402609526252) | 14 | 2 | 9 | 28856 | 34 | ||
54703 | 196389 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 93 Stillman St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6013924.26567 | 2112893.70041 | 37.7823864349182 | -122.395480022606 | (37.7823864349182, -122.395480022606) | 6 | 2 | 9 | 28856 | 6 | |||
54779 | 196387 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 462 Stillman St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6013895.88765 | 2112864.30367 | 37.7823041397518 | -122.395576138553 | (37.7823041397518, -122.395576138553) | 6 | 2 | 9 | 28856 | 6 | |||
55239 | 67709 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 87 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1992 12:00:00 AM | 10 | Permit Number 31320 | 6013781.91426 | 2112762.09602 | 37.7820171606904 | -122.395963274202 | (37.7820171606904, -122.395963274202) | 6 | 2 | 9 | 28856 | 6 | ||
56970 | 196417 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 74 Langton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010044.80056 | 2110849.16971 | 37.776556092323 | -122.408757040407 | (37.776556092323, -122.408757040407) | 8 | 2 | 9 | 28853 | 34 | |||
58505 | 196409 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1143 Howard St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 6009598.37036 | 2111065.11658 | 37.7771240168943 | -122.410316628528 | (37.7771240168943, -122.410316628528) | 8 | 2 | 9 | 28853 | 34 | |||
59035 | 102208 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 89X Elgin Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | Permit Number 30082 | 6005852.4 | 2108559.9 | 37.7700345996314 | -122.423097025843 | (37.7700345996314, -122.423097025843) | 8 | 2 | 5 | 28853 | 19 | |
60160 | 196420 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 82 Langton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6010086.24135 | 2110805.69337 | 37.7764390374799 | -122.408610616413 | (37.7764390374799, -122.408610616413) | 8 | 2 | 9 | 28853 | 34 | |||
60228 | 44086 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 500 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43605 | 6013734.19002 | 2112474.65205 | 37.7812252500735 | -122.396108228707 | (37.7812252500735, -122.396108228707) | 6 | 2 | 9 | 28856 | 34 | |
67822 | 196410 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1143 Howard St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6009614.35227 | 2111076.88274 | 37.7771572198736 | -122.410262172786 | (37.7771572198736, -122.410262172786) | 8 | 2 | 9 | 28853 | 34 | |||
69725 | 31855 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 15 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35301 | 6009805.81882643 | 2111161.45127671 | 37.7774001559158 | -122.409605796854 | (37.7774001559158, -122.409605796854) | 8 | 2 | 9 | 28853 | 34 | ||
75984 | 38754 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 133 Shipley St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | 3 | Permit Number 40630 | 6012174.72166 | 2112365.01303 | 37.7808373158384 | -122.401495543689 | (37.7808373158384, -122.401495543689) | 6 | 2 | 9 | 28856 | 34 | ||
76543 | 196398 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 380 Clara St | 3 | : | Tree | Private 2 | 1 | Width 2ft | 6011290.67787 | 2111282.09016 | 37.7778144947827 | -122.404477648835 | (37.7778144947827, -122.404477648835) | 14 | 2 | 9 | 28856 | 34 | |||
77783 | 196374 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 135 Shipley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012209.83003 | 2112433.27452 | 37.7810267049661 | -122.401378884542 | (37.7810267049661, -122.401378884542) | 6 | 2 | 9 | 28856 | 34 | |||
80402 | 64483 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 55X Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1994 12:00:00 AM | Permit Number 25357 | 6014099.57937836 | 2112818.90611884 | 37.7821908163878 | -122.394868269842 | (37.7821908163878, -122.394868269842) | 6 | 2 | 9 | 28856 | 6 | ||
81494 | 196402 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 136 Langton St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6010324.85595 | 2110562.99084 | 37.7757859938593 | -122.407768059545 | (37.7757859938593, -122.407768059545) | 8 | 2 | 9 | 28853 | 34 | |||
83539 | 38753 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 133 Shipley St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | 1 | Permit Number 40630 | 6012187.7155 | 2112376.5476 | 37.7808697121074 | -122.40145140226 | (37.7808697121074, -122.40145140226) | 6 | 2 | 9 | 28856 | 34 | ||
84160 | 196419 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 82 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6010076.8083 | 2110817.30643 | 37.7764703959162 | -122.408644067583 | (37.7764703959162, -122.408644067583) | 8 | 2 | 9 | 28853 | 34 | |||
84781 | 196394 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 497 03rd St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6013753.77821 | 2112514.40047 | 37.7813354799985 | -122.396043249122 | (37.7813354799985, -122.396043249122) | 6 | 2 | 9 | 28856 | 34 | |||
86120 | 196408 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 22 Rausch St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009625.06025 | 2110948.02453 | 37.7768040057292 | -122.41021603036 | (37.7768040057292, -122.41021603036) | 8 | 2 | 9 | 28853 | 34 | |||
90958 | 196383 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 172 Clara St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6012113.23171 | 2112074.9324 | 37.7800373904398 | -122.401687873618 | (37.7800373904398, -122.401687873618) | 6 | 2 | 9 | 28856 | 34 | |||
91786 | 196379 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 135 Clara St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6012397.66121 | 2112347.77768 | 37.7808024284316 | -122.400723071038 | (37.7808024284316, -122.400723071038) | 6 | 2 | 9 | 28856 | 34 | |||
94321 | 40325 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 655 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/1999 12:00:00 AM | 4 | Permit Number 41463 | 6013209.4791 | 2113639.3788 | 37.7843941128313 | -122.398005213512 | (37.7843941128313, -122.398005213512) | 6 | 2 | 9 | 28856 | 6 | ||
94465 | 42206 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 41 Decatur St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | Permit Number 42477 | 6010764.11568001 | 2109415.80056324 | 37.772660655142 | -122.406167699971 | (37.772660655142, -122.406167699971) | 14 | 2 | 9 | 28853 | 34 | |||
94971 | 196413 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 18 Langton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6009790.62694 | 2111119.41573 | 37.7772838848824 | -122.409655383101 | (37.7772838848824, -122.409655383101) | 8 | 2 | 9 | 28853 | 34 | |||
97247 | 196375 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 135 Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012200.49879 | 2112422.57342 | 37.7809968015951 | -122.401410413864 | (37.7809968015951, -122.401410413864) | 6 | 2 | 9 | 28856 | 34 | |||
99238 | 196414 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 72 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010005.6719 | 2110890.86599 | 37.7766683888663 | -122.408895340869 | (37.7766683888663, -122.408895340869) | 8 | 2 | 9 | 28853 | 34 | |||
100936 | 196380 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 135 Clara St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012381.80562 | 2112329.94836 | 37.7807525888897 | -122.400776670626 | (37.7807525888897, -122.400776670626) | 6 | 2 | 9 | 28856 | 34 | |||
102372 | 196395 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 260 Clara St | 3 | : | Tree | Private 2 | 9 | Width 3ft | 6011460.59942 | 2111454.8789 | 37.7782984271806 | -122.403901990095 | (37.7782984271806, -122.403901990095) | 14 | 2 | 9 | 28856 | 34 | |||
107191 | 196411 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 18 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009748.50589 | 2111160.13618 | 37.7773933332614 | -122.40980396908 | (37.7773933332614, -122.40980396908) | 8 | 2 | 9 | 28853 | 34 | |||
110818 | 44089 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 500 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43605 | 6013788.61209882 | 2112522.22157888 | 37.7813588929752 | -122.395923288248 | (37.7813588929752, -122.395923288248) | 6 | 2 | 9 | 28856 | 34 | |
116087 | 38752 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 133 Shipley St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | 3 | Permit Number 40630 | 6012228.62933 | 2112416.55663 | 37.7809818503781 | -122.40131267285 | (37.7809818503781, -122.40131267285) | 6 | 2 | 9 | 28856 | 34 | ||
117333 | 196422 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 5 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6009795.26229 | 2111148.209 | 37.7773632041902 | -122.409641380638 | (37.7773632041902, -122.409641380638) | 8 | 2 | 9 | 28853 | 34 | |||
117878 | 196382 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 135 Clara St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012355.92865 | 2112312.32296 | 37.7807027502657 | -122.400864953468 | (37.7807027502657, -122.400864953468) | 6 | 2 | 9 | 28856 | 34 | |||
119235 | 196388 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 462 Stillman St | 4 | : | Tree | Private 2 | 1 | Width 3ft | 6013913.95715 | 2112880.07634 | 37.7823484529672 | -122.395514731015 | (37.7823484529672, -122.395514731015) | 6 | 2 | 9 | 28856 | 6 | |||
120605 | 196385 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 462 Stillman St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6013873.09616 | 2112844.01572 | 37.7822471659153 | -122.395653565657 | (37.7822471659153, -122.395653565657) | 6 | 2 | 9 | 28856 | 6 | |||
126063 | 102207 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 89X Elgin Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | Permit Number 30082 | 6005852.4 | 2108559.9 | 37.7700345996314 | -122.423097025843 | (37.7700345996314, -122.423097025843) | 8 | 2 | 5 | 28853 | 19 | |
129222 | 42207 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 41 Decatur St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42477 | 6010764.11568001 | 2109415.80056324 | 37.772660655142 | -122.406167699971 | (37.772660655142, -122.406167699971) | 14 | 2 | 9 | 28853 | 34 | ||
132070 | 196404 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 482 10th St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6009690.27769 | 2108658.23097 | 37.7705204219146 | -122.409828750806 | (37.7705204219146, -122.409828750806) | 8 | 2 | 9 | 28853 | 34 | |||
133203 | 38750 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 133 Shipley St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | 3 | Permit Number 40630 | 6012258.40846 | 2112446.8085 | 37.7810665763953 | -122.40121177791 | (37.7810665763953, -122.40121177791) | 6 | 2 | 9 | 28856 | 34 | ||
134551 | 95827 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 144A Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767562 | 6010353.30698 | 2110532.02613 | 37.7757025646591 | -122.407667456007 | (37.7757025646591, -122.407667456007) | 8 | 2 | 9 | 28853 | 34 |
136438 | 196416 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 74 Langton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010037.74833 | 2110859.12442 | 37.7765830306283 | -122.408782138683 | (37.7765830306283, -122.408782138683) | 8 | 2 | 9 | 28853 | 34 | |||
137367 | 196381 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 135 Clara St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012369.74132 | 2112319.30273 | 37.7807226855437 | -122.400817659004 | (37.7807226855437, -122.400817659004) | 6 | 2 | 9 | 28856 | 34 | |||
143467 | 38758 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 133 Shipley St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | 3 | Permit Number 40630 | 6012273.298 | 2112461.93462 | 37.7811089398776 | -122.401161330453 | (37.7811089398776, -122.401161330453) | 6 | 2 | 9 | 28856 | 34 | ||
145706 | 196390 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 93 Stillman St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6013936.7797 | 2112901.90047 | 37.7824096464379 | -122.395437303898 | (37.7824096464379, -122.395437303898) | 6 | 2 | 9 | 28856 | 6 | |||
150236 | 196391 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 93 Stillman St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6013949.37152 | 2112913.94153 | 37.7824434087757 | -122.395394585209 | (37.7824434087757, -122.395394585209) | 6 | 2 | 9 | 28856 | 6 | |||
153987 | 196405 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 482 10th St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6009655.4576 | 2108693.13255 | 37.7706143021254 | -122.409951658457 | (37.7706143021254, -122.409951658457) | 8 | 2 | 9 | 28853 | 34 | |||
159158 | 196400 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 380x Clara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6011308.09655 | 2111275.91215 | 37.7777985048225 | -122.404416956276 | (37.7777985048225, -122.404416956276) | 14 | 2 | 9 | 28856 | 34 | |||
159550 | 196401 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 403 06th St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6011437.38165 | 2110998.36777 | 37.7770436561708 | -122.403950175767 | (37.7770436561708, -122.403950175767) | 14 | 2 | 9 | 28853 | 34 | |||
160597 | 44090 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 500 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43605 | 6013747.9947 | 2112490.58767 | 37.7812697737139 | -122.396061588087 | (37.7812697737139, -122.396061588087) | 6 | 2 | 9 | 28856 | 34 | |
164374 | 88189 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 123 Dore St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51194 | 6009069 | 2109644 | 37.7731922763614 | -122.412047438663 | (37.7731922763614, -122.412047438663) | 8 | 2 | 9 | 28853 | 34 | |||
165564 | 40228 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 101 South Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1999 12:00:00 AM | Permit Number 41410 | 6014331.14035058 | 2112607.2540326 | 37.7816225406641 | -122.394052345281 | (37.7816225406641, -122.394052345281) | 6 | 2 | 9 | 28856 | 6 | |||
171303 | 196396 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 380 Clara St | 1 | : | Tree | Private 2 | 1 | Width 2ft | 6011313.59863 | 2111303.12635 | 37.7778735361758 | -122.404399838608 | (37.7778735361758, -122.404399838608) | 14 | 2 | 9 | 28856 | 34 | |||
173650 | 196397 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 380 Clara St | 2 | : | Tree | Private 2 | 1 | Width 2ft | 6011301.22079 | 2111291.73097 | 37.7778415553936 | -122.404441855801 | (37.7778415553936, -122.404441855801) | 14 | 2 | 9 | 28856 | 34 | |||
174208 | 196399 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 380 Clara St | 1 | : | Tree | Private 2 | 1 | Width 2ft | 6011297.10381 | 2111266.2805 | 37.7777714442324 | -122.404454306035 | (37.7777714442324, -122.404454306035) | 14 | 2 | 9 | 28856 | 34 | |||
177817 | 50953 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 65 Pearl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/2004 12:00:00 AM | Permit Number 47447 | 6005656.06953929 | 2108672.78639113 | 37.7703334774934 | -122.423784158633 | (37.7703334774934, -122.423784158633) | 8 | 2 | 5 | 28853 | 19 | ||
178542 | 66764 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 49 Pearl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1991 12:00:00 AM | Permit Number 30020 | 6005651.12657979 | 2108762.24464985 | 37.7705788293688 | -122.423807618255 | (37.7705788293688, -122.423807618255) | 8 | 2 | 5 | 28853 | 19 | ||
181908 | 196393 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 93 Stillman St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6013990.37233 | 2112956.91555 | 37.7825636859099 | -122.395255750564 | (37.7825636859099, -122.395255750564) | 6 | 2 | 9 | 28856 | 6 | |||
182838 | 91340 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 829 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2009 12:00:00 AM | 3x3 | Permit Number 52060 | 6012100 | 2112601 | 37.7814811117781 | -122.401770636493 | (37.7814811117781, -122.401770636493) | 6 | 2 | 9 | 28856 | 34 | ||
187102 | 67710 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 99 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | 7 | Permit Number 31321 | 6013724.69743 | 2112718.68187 | 37.7818947719595 | -122.396158176154 | (37.7818947719595, -122.396158176154) | 6 | 2 | 9 | 28856 | 6 | |
188503 | 196412 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 18 Langton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6009772.78472 | 2111137.69481 | 37.7773330751096 | -122.409718395893 | (37.7773330751096, -122.409718395893) | 8 | 2 | 9 | 28853 | 34 | |||
3849 | 27720 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/11/2015 06:49:00 AM | 3 | 3X3 | 6015137.8598649 | 2101142.4987414 | 37.7501876266135 | -122.390460137824 | (37.7501876266135, -122.390460137824) | 10 | 3 | 8 | 28856 | 1 | ||
4233 | 27745 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1399 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6014867.8526066 | 2101105.5872465 | 37.7500712934283 | -122.391391267014 | (37.7500712934283, -122.391391267014) | 10 | 3 | 8 | 28856 | 1 | ||
8785 | 178959 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1333 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007585.1415 | 2091886.23741 | 37.7243500958617 | -122.415922582174 | (37.7243500958617, -122.415922582174) | 9 | 3 | 7 | 309 | 28 | |||
11092 | 74333 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1118 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6015132.5367 | 2090213.511 | 37.720178552846 | -122.389715298726 | (37.720178552846, -122.389715298726) | 10 | 3 | 8 | 58 | 1 | |||
11462 | 38558 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1534 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40523 | 6015743.77247492 | 2095689.90327715 | 37.7352495140639 | -122.387984392406 | (37.7352495140639, -122.387984392406) | 10 | 3 | 8 | 58 | 1 | ||
14432 | 178904 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 10x Mansell St | 4 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6011792.88406 | 2090769.73397 | 37.7215200714836 | -122.401298496839 | (37.7215200714836, -122.401298496839) | 10 | 3 | 8 | 309 | 28 | |||
15474 | 67662 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1544 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | Permit Number 31263 | 6016003.68231462 | 2097240.31166612 | 37.739521017402 | -122.387193890351 | (37.739521017402, -122.387193890351) | 10 | 3 | 8 | 58 | 1 | ||
16616 | 43283 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 872 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 6 | Permit Number 43052 | 6010937.3393 | 2090651.38579 | 37.7211473420438 | -122.404247572584 | (37.7211473420438, -122.404247572584) | 10 | 3 | 7 | 309 | 28 | |
18344 | 40022 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1535 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 9 | Permit Number 41267 | 6015717.1223 | 2095636.9971 | 37.7351027679039 | -122.388072841786 | (37.7351027679039, -122.388072841786) | 10 | 3 | 8 | 58 | 1 | |
18417 | 4023 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1900 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/2015 02:44:00 PM | 3 | 3X3 | 6013444.0079121 | 2101040.051797 | 37.7498122193832 | -122.396310443681 | (37.7498122193832, -122.396310443681) | 10 | 3 | 8 | 28856 | 1 | ||
20130 | 68264 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 381 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32070 | 6009731.82582651 | 2092664.31257859 | 37.72660698205 | -122.408556624594 | (37.72660698205, -122.408556624594) | 10 | 3 | 7 | 309 | 28 | ||
20299 | 43280 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 731 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43050 | 6009363.88058907 | 2092426.70066476 | 37.7259339362736 | -122.409811838204 | (37.7259339362736, -122.409811838204) | 9 | 3 | 7 | 309 | 28 | ||
20375 | 27754 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1299 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015153.848397 | 2101092.2403929 | 37.7500505146893 | -122.390401336874 | (37.7500505146893, -122.390401336874) | 10 | 3 | 8 | 58 | 1 | ||
23329 | 178962 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 217 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007226.63785 | 2092632.02114 | 37.7263776956646 | -122.417214704709 | (37.7263776956646, -122.417214704709) | 9 | 3 | 7 | 309 | 28 | |||
25564 | 178956 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1393 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007451.98675 | 2091842.90418 | 37.724223625092 | -122.416379812775 | (37.724223625092, -122.416379812775) | 9 | 3 | 7 | 309 | 28 | |||
25815 | 27759 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1099X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/25/2005 12:00:00 AM | 4 | 3x3 | 6015711.8179102 | 2101113.2850563 | 37.750139234821 | -122.388473299437 | (37.750139234821, -122.388473299437) | 10 | 3 | 8 | 58 | 1 | ||
26757 | 4027 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2150 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6012617.9559004 | 2100994.1740901 | 37.7496402484926 | -122.399163766262 | (37.7496402484926, -122.399163766262) | 10 | 3 | 8 | 58 | 1 | ||
36197 | 67647 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1980 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | Permit Number 31246 | 6013237.51927358 | 2096157.49523352 | 37.7363942565122 | -122.396682257399 | (37.7363942565122, -122.396682257399) | 10 | 3 | 8 | 58 | 1 | ||
37006 | 38189 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 541 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/2013 12:00:00 AM | Permit Number 770070 | 6011097.98403945 | 2092306.25144746 | 37.7257002373273 | -122.403808654284 | (37.7257002373273, -122.403808654284) | 10 | 3 | 7 | 309 | 28 | ||
38556 | 196406 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1021 Minnesota St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6015301.01099 | 2103753.62638 | 37.7573662793475 | -122.390078334671 | (37.7573662793475, -122.390078334671) | 10 | 3 | 8 | 28856 | 29 | |||
42727 | 67682 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 56 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | Permit Number 31286 | 6012201.16288031 | 2095460.48706817 | 37.7344226836872 | -122.400216460292 | (37.7344226836872, -122.400216460292) | 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) );