trees
1,985 rows where qSpecies_id = 83 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2762 | 46200 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
19620 | 46201 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
61278 | 240133 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 0 Chattanooga St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004672.52486 | 2103529.70008 | 37.7561562172456 | -122.426819912015 | (37.7561562172456, -122.426819912015) | 2 | 4 | 5 | 28862 | 22 | |||
150497 | 240131 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 0 Chattanooga St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004671.77899 | 2103561.17999 | 37.7562426115098 | -122.426824733295 | (37.7562426115098, -122.426824733295) | 2 | 4 | 5 | 28862 | 22 | |||
187007 | 240132 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 0 Chattanooga St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004672.38894 | 2103545.66672 | 37.7562000502026 | -122.426821519118 | (37.7562000502026, -122.426821519118) | 2 | 4 | 5 | 28862 | 22 | |||
59761 | 102145 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 0X Ford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003601 | 2105679 | 37.7619970392507 | -122.430678972901 | (37.7619970392507, -122.430678972901) | 15 | 4 | 5 | 28862 | 3 | |||
98802 | 102146 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 0X Ford St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003601 | 2105679 | 37.7619970392507 | -122.430678972901 | (37.7619970392507, -122.430678972901) | 15 | 4 | 5 | 28862 | 3 | |||
138349 | 102144 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 0X Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003601 | 2105679 | 37.7619970392507 | -122.430678972901 | (37.7619970392507, -122.430678972901) | 15 | 4 | 5 | 28862 | 3 | |||
11660 | 120676 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1 Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003502 | 2105614 | 37.7618129556584 | -122.431016735878 | (37.7618129556584, -122.431016735878) | 15 | 4 | 5 | 28862 | 3 | ||||
107184 | 213926 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996340.85636 | 2106804.33971 | 37.7646729463343 | -122.455870188675 | (37.7646729463343, -122.455870188675) | 15 | 5 | 11 | 29492 | 12 | |||
33930 | 213991 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1 Merced Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5995344.90173 | 2100199.2685 | 37.7464798897511 | -122.458836668093 | (37.7464798897511, -122.458836668093) | 1 | 8 | 4 | 59 | 40 | |||
16204 | 114507 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 10 LOMBARD ST | 2 | Back Yard : Cutout | Tree | Port 6 | 4x4 | 6011932 | 2120995 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | 3 | 1 | 10 | 28860 | 6 | ||||
15188 | 180603 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | Width 3ft | 6009034.51206 | 2093748.44623 | 37.7295447050207 | -122.411043765455 | (37.7295447050207, -122.411043765455) | 9 | 3 | 7 | 309 | 28 | ||
64826 | 179314 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 Hamilton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009038.30764 | 2093734.45696 | 37.7295065063148 | -122.411029655989 | (37.7295065063148, -122.411029655989) | 9 | 3 | 7 | 309 | 28 | |||
101046 | 179315 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 Hamilton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009040.95061 | 2093717.83367 | 37.7294610105146 | -122.411019345266 | (37.7294610105146, -122.411019345266) | 9 | 3 | 7 | 309 | 28 | |||
136697 | 239151 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 Octavia St | 2 | : | Tree | DPW 1 | 04/15/2017 01:58:00 PM | 3 | Width 4ft | 6005731.03459 | 2109700.90805 | 37.7731606839629 | -122.423597962203 | (37.7731606839629, -122.423597962203) | 7 | 9 | 11 | 28852 | 10 | ||
15527 | 19972 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 STAIRWAY44 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 36 | |||||||||||||
168462 | 67075 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 100 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1995 12:00:00 AM | Permit Number 30469 | 6007674.59209912 | 2096541.81182002 | 37.7371383234242 | -122.415942891576 | (37.7371383234242, -122.415942891576) | 2 | 7 | 7 | 28859 | 2 | ||
32346 | 179313 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 Yale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006918.39852 | 2093488.03593 | 37.728710780776 | -122.418340943684 | (37.728710780776, -122.418340943684) | 9 | 3 | 7 | 309 | 5 | |||
117753 | 14770 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1000X McAllister St | 5 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 02/06/2016 08:42:00 AM | 3 | 4x4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | ||
143126 | 14773 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1000X McAllister St | 8 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 05/13/1992 12:00:00 AM | 6 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | ||
185242 | 41522 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1001 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2000 12:00:00 AM | 3 | Permit Number 42063 | 6014186.00908 | 2106172.78785 | 37.7639468669737 | -122.39410383682 | (37.7639468669737, -122.39410383682) | 14 | 3 | 8 | 28856 | 29 | ||
13512 | 259080 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1001 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
61565 | 213950 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1006 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995061.44128 | 2090626.04133 | 37.7201778494978 | -122.459123753274 | (37.7201778494978, -122.459123753274) | 9 | 8 | 6 | 28861 | 24 | |||
92377 | 240153 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1008 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5998136.29263 | 2106764.45676 | 37.7646663192052 | -122.449657403985 | (37.7646663192052, -122.449657403985) | 15 | 5 | 11 | 29492 | 9 | |||
87382 | 16010 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100X Monterey Blvd | 4 | Median : Cutout | Tree | DPW 1 | 2 | 4 | 6001411.9312264 | 2094682.0759854 | 37.7316778334432 | -122.437462576871 | (37.7316778334432, -122.437462576871) | 9 | 7 | 4 | 63 | 40 | |||
7988 | 24147 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016689.05107 | 2095205.54183 | 37.7339718785836 | -122.384682457242 | (37.7339718785836, -122.384682457242) | 10 | 3 | 8 | 58 | 1 | |||
45441 | 24145 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016696.89665 | 2095171.76192 | 37.7338795595807 | -122.384652980151 | (37.7338795595807, -122.384652980151) | 10 | 3 | 8 | 58 | 1 | |||
74210 | 24149 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 100X Whitney Young Cir | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016357.373923 | 2096088.8828188 | 37.736379006836 | -122.385890729183 | (37.736379006836, -122.385890729183) | 10 | 3 | 8 | 58 | 1 | ||
77507 | 24151 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 100X Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016357.373923 | 2096088.8828188 | 37.736379006836 | -122.385890729183 | (37.736379006836, -122.385890729183) | 10 | 3 | 8 | 58 | 1 | ||
81020 | 197127 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Newhall St | 13 | : | Tree | Private 2 | 3 | Width 3ft | 6017303.08049 | 2098110.93394 | 37.7419834431736 | -122.382761660942 | (37.7419834431736, -122.382761660942) | 10 | 3 | 8 | 58 | 1 | |||
16496 | 60642 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20270 | 6004901.36876785 | 2097539.55337894 | 37.7397215914528 | -122.425602180558 | (37.7397215914528, -122.425602180558) | 2 | 7 | 5 | 63 | 7 | ||
2378 | 239239 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Scott St | 1 | : | Tree | Private 2 | 20 | Width 6ft | 6002329.06188 | 2108869.34471 | 37.7706848027038 | -122.435306320439 | (37.7706848027038, -122.435306320439) | 15 | 5 | 11 | 29492 | 9 | |||
116797 | 41900 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2000 12:00:00 AM | Permit Number 42265 | 6002336.18060938 | 2108825.44123893 | 37.7705646588804 | -122.435278555813 | (37.7705646588804, -122.435278555813) | 15 | 5 | 11 | 29492 | 9 | |||
30941 | 136212 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Spruce St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997026.47763 | 2115953.79939 | 37.7898342954728 | -122.454159706 | (37.7898342954728, -122.454159706) | 11 | 6 | 1 | 54 | 31 | |||
173859 | 136211 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Spruce St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5997026.34564 | 2115964.00812 | 37.7898623183414 | -122.454160900321 | (37.7898623183414, -122.454160900321) | 11 | 6 | 1 | 54 | 31 | |||
5967 | 252969 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5998071 | 2087307 | 37.7112370808248 | -122.448481858962 | (37.7112370808248, -122.448481858962) | 9 | 7 | 6 | 28861 | 25 | ||||
155154 | 258328 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998071 | 2087307 | 37.7112370808248 | -122.448481858962 | (37.7112370808248, -122.448481858962) | 9 | 7 | 6 | 28861 | 25 | ||||
167286 | 5222 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1010 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/24/2014 12:00:00 AM | 3 | 4x4 | 6001485.7958586 | 2111861.2482699 | 37.7788518948545 | -122.438437575376 | (37.7788518948545, -122.438437575376) | 15 | 5 | 11 | 29490 | 41 | ||
105749 | 197116 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1015 Rhode Island St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6011950.21534 | 2103491.63171 | 37.7564604866852 | -122.40164836548 | (37.7564604866852, -122.40164836548) | 10 | 3 | 8 | 28856 | 29 | |||
449 | 252970 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101X Whipple Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/26/2019 12:00:00 AM | 3 | |||||||||||||
5684 | 83143 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6016637.51216 | 2095504.68596 | 37.7347904181313 | -122.384881478104 | (37.7347904181313, -122.384881478104) | 10 | 3 | 8 | 58 | 1 | |||
55456 | 24180 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101X Whitney Young Cir | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6016621.33395 | 2095295.74377 | 37.7342158098126 | -122.384922860422 | (37.7342158098126, -122.384922860422) | 10 | 3 | 8 | 58 | 1 | |||
64663 | 24178 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101X Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2001 12:00:00 AM | 4 | 4x3 | 6016619.18629 | 2095310.93644 | 37.7342574070589 | -122.384931343733 | (37.7342574070589, -122.384931343733) | 10 | 3 | 8 | 58 | 1 | ||
110946 | 24179 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101X Whitney Young Cir | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/1990 12:00:00 AM | 12 | 5x3 | 6016625.58798 | 2095312.02915 | 37.7342607615082 | -122.384909286932 | (37.7342607615082, -122.384909286932) | 10 | 3 | 8 | 58 | 1 | ||
183966 | 197150 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 102 Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6016678.04362 | 2095528.85162 | 37.7348590139212 | -122.38474302839 | (37.7348590139212, -122.38474302839) | 10 | 3 | 8 | 58 | 1 | |||
11654 | 259082 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1023 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009473.49904 | 2087244.25049 | 37.7117101453965 | -122.409067379874 | (37.7117101453965, -122.409067379874) | 9 | 7 | 8 | 309 | 39 | |||
49186 | 239315 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1024 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010214.49456 | 2103222.56761 | 37.7556246873555 | -122.407632158506 | (37.7556246873555, -122.407632158506) | 2 | 4 | 7 | 28859 | 19 | |||
19372 | 259083 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1029 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009458.60985 | 2087249.80978 | 37.7117245759679 | -122.409119233208 | (37.7117245759679, -122.409119233208) | 9 | 7 | 8 | 309 | 39 | |||
36052 | 179295 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 103 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004297.98606 | 2093012.31391 | 37.7272566975202 | -122.42736600014 | (37.7272566975202, -122.42736600014) | 9 | 7 | 6 | 28861 | 5 | |||
110585 | 14783 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1037 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004216.0719046 | 2111827.8420521 | 37.7789150924062 | -122.428990088078 | (37.7789150924062, -122.428990088078) | 7 | 9 | 11 | 29490 | 41 | |||
184771 | 14782 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1037 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 4X4 | 6004198.5372 | 2111824.0669 | 37.7789037342236 | -122.429050478372 | (37.7789037342236, -122.429050478372) | 7 | 9 | 11 | 29490 | 41 | |||
68572 | 24482 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 103X Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002240.5138934 | 2096668.0977393 | 37.7371780656004 | -122.434739971035 | (37.7371780656004, -122.434739971035) | 2 | 7 | 5 | 63 | 7 | |||
11829 | 259084 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1041 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009428.83146 | 2087260.92835 | 37.7117534370142 | -122.409222939968 | (37.7117534370142, -122.409222939968) | 9 | 7 | 8 | 309 | 39 | |||
75723 | 141928 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1050 MCALLISTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004234.8996 | 2111882.5726 | 37.7790664346643 | -122.428928858602 | (37.7790664346643, -122.428928858602) | 7 | 9 | 11 | 29490 | 41 | |||
77881 | 141931 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1050 MCALLISTER ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004116.6344 | 2111867.0624 | 37.7790171527246 | -122.42933687954 | (37.7790171527246, -122.42933687954) | 7 | 9 | 11 | 29490 | 41 | |||
60277 | 101046 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1050 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 774347 | 6012049.48691 | 2119300.00717 | 37.7998721792109 | -122.402416569092 | (37.7998721792109, -122.402416569092) | 3 | 1 | 10 | 28860 | 6 | ||
68810 | 101047 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1050 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774347 | 6012043 | 2119296 | 37.799860814363 | -122.402438734441 | (37.799860814363, -122.402438734441) | 3 | 1 | 10 | 28860 | 6 | |
143077 | 61792 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1053 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1985 12:00:00 AM | Permit Number 21815 | 6012220.91982442 | 2103494.12981341 | 37.7564824480415 | -122.400712343497 | (37.7564824480415, -122.400712343497) | 10 | 3 | 8 | 28856 | 29 | ||
1561 | 24107 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 105X Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.081358 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | 10 | 3 | 8 | 58 | 1 | ||
61107 | 24109 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 105X Whitney Young Cir | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.081358 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | 10 | 3 | 8 | 58 | 1 | ||
100588 | 24094 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 105X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.081358 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | 10 | 3 | 8 | 58 | 1 | ||
123317 | 24106 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 105X Whitney Young Cir | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.081358 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | 10 | 3 | 8 | 58 | 1 | ||
184542 | 24098 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 105X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.081358 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | 10 | 3 | 8 | 58 | 1 | ||
67571 | 60613 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 106 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20237 | 6004863.02785957 | 2097589.48802411 | 37.7398565341458 | -122.425738300436 | (37.7398565341458, -122.425738300436) | 2 | 7 | 5 | 63 | 7 | ||
63506 | 197158 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 106 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6016583.16711 | 2095682.22839 | 37.7352749081106 | -122.385081735533 | (37.7352749081106, -122.385081735533) | 10 | 3 | 8 | 58 | 1 | |||
176763 | 197157 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 106 Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6016598.78719 | 2095669.6865 | 37.7352413346217 | -122.385026857123 | (37.7352413346217, -122.385026857123) | 10 | 3 | 8 | 58 | 1 | |||
85412 | 4406 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1060 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6004384.57785 | 2102734.51473 | 37.7539565402887 | -122.427759074928 | (37.7539565402887, -122.427759074928) | 2 | 4 | 5 | 28862 | 22 | |||
1920 | 213973 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5995027.24606 | 2091045.40909 | 37.7213273674346 | -122.459272306869 | (37.7213273674346, -122.459272306869) | 9 | 8 | 6 | 28861 | 24 | |||
39384 | 213968 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995026.49617 | 2091185.65951 | 37.7217124184688 | -122.459285050266 | (37.7217124184688, -122.459285050266) | 9 | 8 | 6 | 28861 | 24 | |||
56476 | 213969 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995027.18674 | 2091165.82123 | 37.7216579869959 | -122.459281227274 | (37.7216579869959, -122.459281227274) | 9 | 8 | 6 | 28861 | 24 | |||
73942 | 213970 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995027.09423 | 2091143.79671 | 37.721597507608 | -122.459279952927 | (37.721597507608, -122.459279952927) | 9 | 8 | 6 | 28861 | 24 | |||
76177 | 213976 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995023.46765 | 2090970.59824 | 37.7211217374705 | -122.459279952923 | (37.7211217374705, -122.459279952923) | 9 | 8 | 6 | 28861 | 24 | |||
124638 | 213975 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995024.51997 | 2091003.24873 | 37.7212114484221 | -122.459278678595 | (37.7212114484221, -122.459278678595) | 9 | 8 | 6 | 28861 | 24 | |||
133184 | 213974 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995026.3935 | 2091022.299 | 37.7212638636298 | -122.459273581222 | (37.7212638636298, -122.459273581222) | 9 | 8 | 6 | 28861 | 24 | |||
145023 | 213972 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995029.65711 | 2091072.52436 | 37.7214019581083 | -122.459265935174 | (37.7214019581083, -122.459265935174) | 9 | 8 | 6 | 28861 | 24 | |||
189124 | 213971 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995026.07265 | 2091112.61421 | 37.7215118291791 | -122.459281227253 | (37.7215118291791, -122.459281227253) | 9 | 8 | 6 | 28861 | 24 | |||
183528 | 91610 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1068 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2016 08:13:00 AM | 3 | 3x3 | 6007601.453035 | 2103438.871938 | 37.7560719916571 | -122.416684224173 | (37.7560719916571, -122.416684224173) | 2 | 4 | 7 | 28859 | 19 | |||
35133 | 36194 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 107 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Permit Number 39260 | 5997029.24357 | 2115938.23155 | 37.7897917089598 | -122.454149011282 | (37.7897917089598, -122.454149011282) | 11 | 6 | 1 | 54 | 31 | |||
180943 | 136213 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 107 Spruce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997027.70911 | 2115921.73522 | 37.7897463264678 | -122.454153128371 | (37.7897463264678, -122.454153128371) | 11 | 6 | 1 | 54 | 31 | |||
13556 | 264663 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1078 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014476.86082 | 2089998.27904 | 37.7195511879651 | -122.391966726039 | (37.7195511879651, -122.391966726039) | 10 | 3 | 8 | 58 | 1 | |||
25494 | 48801 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
26416 | 48800 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
32999 | 48812 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014467.05373 | 2102353.10418 | 37.7534744568981 | -122.392864530587 | (37.7534744568981, -122.392864530587) | 10 | 3 | 8 | 28856 | 29 | ||
45599 | 48808 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
47853 | 48805 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
54634 | 48797 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
64046 | 48811 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | 7 | Permit Number 46042 | 6014468.77093 | 2102318.37211 | 37.7533791854235 | -122.392856162375 | (37.7533791854235, -122.392856162375) | 10 | 3 | 8 | 28856 | 29 | ||
68863 | 48795 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
79508 | 48798 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
79768 | 48814 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
83659 | 48807 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
88985 | 48809 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | 3 | Permit Number 46042 | 6014468.62547 | 2102279.90426 | 37.7532735528322 | -122.392853974356 | (37.7532735528322, -122.392853974356) | 10 | 3 | 8 | 28856 | 29 | ||
95612 | 48796 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
97852 | 48813 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
100381 | 48799 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014465.83632 | 2102364.69447 | 37.7535062137414 | -122.392869551502 | (37.7535062137414, -122.392869551502) | 10 | 3 | 8 | 28856 | 29 | ||
108762 | 48793 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
112831 | 48815 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014467.97393 | 2102326.82142 | 37.7534023411579 | -122.392859509671 | (37.7534023411579, -122.392859509671) | 10 | 3 | 8 | 28856 | 29 | ||
132695 | 48806 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
136597 | 48802 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 |
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) );