trees
3,709 rows where qSpecies_id = 9 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
166183 | 210661 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Maywood Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994208.63776 | 2095900.82229 | 37.7346120510927 | -122.462453985083 | (37.7346120510927, -122.462453985083) | 9 | 8 | 4 | 59 | 40 | |||
28475 | 210659 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Pinehurst Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993556.39391 | 2093703.65355 | 37.7285415859236 | -122.464549507963 | (37.7285415859236, -122.464549507963) | 9 | 8 | 4 | 59 | 40 | |||
107360 | 42019 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | Permit Number 42345 | 5993530.78029049 | 2093639.27854134 | 37.7283633513404 | -122.464633382328 | (37.7283633513404, -122.464633382328) | 9 | 8 | 4 | 59 | 40 | |||
151359 | 210658 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993547.0242 | 2093685.64408 | 37.7284915961896 | -122.464580592135 | (37.7284915961896, -122.464580592135) | 9 | 8 | 4 | 59 | 40 | |||
180870 | 42021 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100 Pinehurst Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | Permit Number 42345 | 5993530.78029049 | 2093639.27854134 | 37.7283633513404 | -122.464633382328 | (37.7283633513404, -122.464633382328) | 9 | 8 | 4 | 59 | 40 | |||
183513 | 42022 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100 Pinehurst Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | Permit Number 42345 | 5993530.78029049 | 2093639.27854134 | 37.7283633513404 | -122.464633382328 | (37.7283633513404, -122.464633382328) | 9 | 8 | 4 | 59 | 40 | |||
15594 | 19769 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY16 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30ST | |||||||||||||
17923 | 19768 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY16 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30ST | |||||||||||||
18560 | 19875 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY33 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
30830 | 253551 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 19 | Back Yard : Yard | Tree | DPW 1 | 09/22/2017 04:40:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
55894 | 253546 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 14 | Back Yard : Yard | Tree | DPW 1 | 09/27/2017 11:50:00 AM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
56235 | 253550 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 18 | Back Yard : Yard | Tree | DPW 1 | 09/27/2017 11:43:00 AM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
58983 | 253548 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 16 | Back Yard : Yard | Tree | DPW 1 | 09/22/2017 04:31:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
61431 | 253549 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 17 | Back Yard : Yard | Tree | DPW 1 | 09/27/2017 11:46:00 AM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
87305 | 253547 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 15 | Back Yard : Yard | Tree | DPW 1 | 09/27/2017 11:40:00 AM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
124108 | 258218 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 1000 North Point St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6005937.91741 | 2121414.48699 | 37.8053349315385 | -122.423715341013 | (37.8053349315385, -122.423715341013) | 5 | 1 | 1 | 28858 | 32 | |||||
111236 | 232992 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1001 Ashbury St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 4ft | 5999171.20733 | 2106627.37895 | 37.7643490914484 | -122.446068061312 | (37.7643490914484, -122.446068061312) | 15 | 5 | 11 | 29492 | 9 | |||
180296 | 88725 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1003 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51659 | 6001771 | 2109412 | 37.7721430915073 | -122.437275523238 | (37.7721430915073, -122.437275523238) | 15 | 5 | 11 | 29492 | 9 | ||
43692 | 88726 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1005 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51659 | 6001742 | 2109408 | 37.7721304598957 | -122.437375549988 | (37.7721304598957, -122.437375549988) | 15 | 5 | 11 | 29492 | 9 | ||
104565 | 245892 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1005 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6001712.4921 | 2109397.5688 | 37.7721001408501 | -122.437476872946 | (37.7721001408501, -122.437476872946) | 15 | 5 | 11 | 29492 | 9 | |||
137166 | 245891 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1009 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6001696.2054 | 2109395.2421 | 37.7720928263506 | -122.437533043207 | (37.7720928263506, -122.437533043207) | 15 | 5 | 11 | 29492 | 9 | |||
6307 | 83045 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6018793.96585 | 2097631.53768 | 37.7407493718785 | -122.377573338964 | (37.7407493718785, -122.377573338964) | 10 | 3 | 8 | 58 | 1 | |||
13702 | 83044 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6018777.54715 | 2097643.31156 | 37.7407807960029 | -122.377630926146 | (37.7407807960029, -122.377630926146) | 10 | 3 | 8 | 58 | 1 | |||
15140 | 83033 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 1 | 6018894.74802 | 2097554.01331 | 37.7405420574702 | -122.377219490814 | (37.7405420574702, -122.377219490814) | 10 | 3 | 8 | 58 | 1 | ||||
44203 | 3575 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
45116 | 83043 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/18/2017 02:49:00 PM | 3 | 6018760.27201 | 2097656.07243 | 37.7408148829885 | -122.377691543139 | (37.7408148829885, -122.377691543139) | 10 | 3 | 8 | 58 | 1 | |||
54162 | 3576 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3x3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
90691 | 3567 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
105856 | 3574 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
146341 | 3568 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
178553 | 3571 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
9934 | 233207 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007340 | 2097733 | 37.7403902459184 | -122.417184114538 | (37.7403902459184, -122.417184114538) | 2 | 7 | 7 | 28859 | 2 | |||
31954 | 115620 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100x Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6012248.32012 | 2106930.54412 | 37.7659196081195 | -122.400859007135 | (37.7659196081195, -122.400859007135) | 14 | 3 | 8 | 28856 | 20 | |||
101385 | 210682 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100x Idora Ave | 6 | Median : Yard | Tree | DPW 1 | 15 | Width 9ft | 5995339.29404 | 2099412.44102 | 37.7443191354124 | -122.4587991034 | (37.7443191354124, -122.4587991034) | 1 | 8 | 4 | 59 | 40 | |||
148300 | 120379 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 25th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5987993.53196 | 2115242.52574 | 37.7873592309741 | -122.485360251255 | (37.7873592309741, -122.485360251255) | 11 | 6 | 1 | 55 | 33 | |||
156318 | 120381 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5987991.90304 | 2115282.62041 | 37.7874692245738 | -122.485368830184 | (37.7874692245738, -122.485368830184) | 11 | 6 | 1 | 55 | 33 | |||
23789 | 3563 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Cargo Way | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018859.49817 | 2097478.39151 | 37.7403324731777 | -122.377336126574 | (37.7403324731777, -122.377336126574) | 10 | 3 | 8 | 58 | 1 | ||
32116 | 3557 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Cargo Way | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 2 | 3X3 | 6018758.22153 | 2097553.75967 | 37.7405338394733 | -122.377691534151 | (37.7405338394733, -122.377691534151) | 10 | 3 | 8 | 58 | 1 | ||
36534 | 3559 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Cargo Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018791.21625 | 2097528.24687 | 37.7404656043104 | -122.377575679878 | (37.7404656043104, -122.377575679878) | 10 | 3 | 8 | 58 | 1 | ||
48057 | 3562 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Cargo Way | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018842.999 | 2097491.0611 | 37.7403663524293 | -122.377394053707 | (37.7403663524293, -122.377394053707) | 10 | 3 | 8 | 58 | 1 | ||
150545 | 3564 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Cargo Way | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 6 | 3X3 | 6018876.34975 | 2097465.88877 | 37.7402990714478 | -122.377276992562 | (37.7402990714478, -122.377276992562) | 10 | 3 | 8 | 58 | 1 | ||
175871 | 3560 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Cargo Way | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 6 | 3X3 | 6018809.63786 | 2097515.71259 | 37.7404322025979 | -122.377511114855 | (37.7404322025979, -122.377511114855) | 10 | 3 | 8 | 58 | 1 | ||
5300 | 194149 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Pennsylvania Ave | 40 | Front Yard : Yard | Tree | Private 2 | 1 | 6014236.41284 | 2106693.24116 | 37.765378718967 | -122.393965939285 | (37.765378718967, -122.393965939285) | 14 | 3 | 8 | 28856 | 20 | ||||
80862 | 194147 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Pennsylvania Ave | 21 | Front Yard : Yard | Tree | Private 2 | 1 | 6014318.41099 | 2106520.50187 | 37.7649089715932 | -122.393670233204 | (37.7649089715932, -122.393670233204) | 14 | 3 | 8 | 310 | 29 | ||||
121396 | 194145 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Pennsylvania Ave | 2 | Front Yard : Yard | Tree | Private 2 | 1 | 6014334.84146 | 2106266.74633 | 37.7642131274542 | -122.393595642523 | (37.7642131274542, -122.393595642523) | 14 | 3 | 8 | 310 | 29 | ||||
132402 | 194146 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Pennsylvania Ave | 11 | Front Yard : Yard | Tree | Private 2 | 1 | 6014326.39851 | 2106410.8143 | 37.7646082374101 | -122.393634928533 | (37.7646082374101, -122.393634928533) | 14 | 3 | 8 | 310 | 29 | ||||
150607 | 194148 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Pennsylvania Ave | 32 | Front Yard : Yard | Tree | Private 2 | 1 | 6014289.98871 | 2106632.9609 | 37.7652161800146 | -122.393776411647 | (37.7652161800146, -122.393776411647) | 14 | 3 | 8 | 310 | 29 | ||||
33630 | 178006 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004071.97549 | 2094334.96699 | 37.730875622499 | -122.428241541412 | (37.730875622499, -122.428241541412) | 9 | 7 | 6 | 28861 | 5 | |||
171010 | 233610 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1014 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009156.0477 | 2103144.90261 | 37.7553521307214 | -122.411287128293 | (37.7553521307214, -122.411287128293) | 2 | 4 | 7 | 28859 | 19 | |||
16998 | 109968 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1019 Hollister Ave | 2 | Front Yard : Yard | Tree | Private 2 | 03/13/2015 12:00:00 AM | 3 | 12x17 | 6014729.1 | 2089712.4 | 37.7187802209924 | -122.391074848752 | (37.7187802209924, -122.391074848752) | 10 | 3 | 8 | 58 | 1 | ||
42155 | 109967 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1019 Hollister Ave | 1 | Front Yard : Yard | Tree | Private 2 | 03/13/2015 12:00:00 AM | 3 | 12x17 | 6014729.1 | 2089712.4 | 37.7187802209924 | -122.391074848752 | (37.7187802209924, -122.391074848752) | 10 | 3 | 8 | 58 | 1 | ||
84135 | 3566 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101X Cargo Way | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018911.95106 | 2097439.80241 | 37.7402294045724 | -122.377152086609 | (37.7402294045724, -122.377152086609) | 10 | 3 | 8 | 58 | 1 | ||
84537 | 3565 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101X Cargo Way | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018894.06666 | 2097453.02118 | 37.740264715549 | -122.377214841296 | (37.740264715549, -122.377214841296) | 10 | 3 | 8 | 58 | 1 | ||
149621 | 3555 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101X Cargo Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018831.8 | 2097475.1 | 37.7403219094469 | -122.377431668566 | (37.7403219094469, -122.377431668566) | 10 | 3 | 8 | 58 | 1 | ||
25642 | 103578 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 101X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | ||||
82365 | 103579 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 101X Laguna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | ||||
115230 | 103577 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 101X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | ||||
136925 | 103576 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 101X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | ||||
140784 | 103575 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 101X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | ||||
49725 | 232993 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1025 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5999120.10377 | 2106539.64026 | 37.7641052645834 | -122.446238501702 | (37.7641052645834, -122.446238501702) | 15 | 5 | 11 | 29492 | 9 | |||
176625 | 233177 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1028 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999101.07568 | 2106447.88478 | 37.7638522403041 | -122.446297713075 | (37.7638522403041, -122.446297713075) | 15 | 5 | 5 | 29492 | 9 | |||
177457 | 56943 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1028 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1974 12:00:00 AM | 3x3 | Permit Number 14193 | 5999097.12659236 | 2106428.06249602 | 37.7637975877357 | -122.446309945678 | (37.7637975877357, -122.446309945678) | 15 | 5 | 5 | 29492 | 9 | ||
147635 | 132021 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1028 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007930.01357 | 2119968.33776 | 37.8014764204703 | -122.416718902151 | (37.8014764204703, -122.416718902151) | 5 | 1 | 10 | 308 | 32 | |||
3784 | 233206 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 103 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007392.99224 | 2097693.10233 | 37.7402836768503 | -122.416998061628 | (37.7402836768503, -122.416998061628) | 2 | 7 | 7 | 28859 | 2 | |||
54899 | 194214 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1030 Le Conte Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013004.48576 | 2089699.06872 | 37.7186477627738 | -122.397035257987 | (37.7186477627738, -122.397035257987) | 10 | 3 | 8 | 58 | 1 | |||
48280 | 233028 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1031 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009195.32545 | 2103132.31552 | 37.7553197722098 | -122.411150404385 | (37.7553197722098, -122.411150404385) | 2 | 4 | 7 | 28859 | 19 | |||
146227 | 233178 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1032 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5999091.07957 | 2106428.33595 | 37.7637979932112 | -122.446330880074 | (37.7637979932112, -122.446330880074) | 15 | 5 | 5 | 29492 | 9 | |||
89353 | 53963 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1034 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/1972 12:00:00 AM | 3x3 | Permit Number 9678 | 5999077.6651474 | 2106402.81511165 | 37.7637271532356 | -122.446375440222 | (37.7637271532356, -122.446375440222) | 15 | 5 | 5 | 29492 | 9 | ||
60263 | 41526 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1036 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2000 12:00:00 AM | Permit Number 42066 | 6018440.91849108 | 2095073.89345371 | 37.7337071281629 | -122.378616510061 | (37.7337071281629, -122.378616510061) | 10 | 3 | 8 | 58 | 1 | |||
32074 | 233065 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1037 Douglass St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001346.41468 | 2100623.4255 | 37.7479876633961 | -122.438114525463 | (37.7479876633961, -122.438114525463) | 2 | 4 | 5 | 28862 | 22 | |||
130595 | 233067 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1037 Douglass St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001344.07448 | 2100653.2187 | 37.7480693353408 | -122.438124751659 | (37.7480693353408, -122.438124751659) | 2 | 4 | 5 | 28862 | 22 | |||
164713 | 233066 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1037 Douglass St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001345.83281 | 2100638.16269 | 37.7480280951206 | -122.438117593069 | (37.7480280951206, -122.438117593069) | 2 | 4 | 5 | 28862 | 22 | |||
192598 | 233064 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1037 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001346.73145 | 2100610.16606 | 37.7479512741444 | -122.438112480405 | (37.7479512741444, -122.438112480405) | 2 | 4 | 5 | 28862 | 22 | |||
24464 | 178026 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 104 Burrows St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011109.90647 | 2093496.75882 | 37.7289697891238 | -122.403851174793 | (37.7289697891238, -122.403851174793) | 10 | 3 | 7 | 309 | 28 | |||
153827 | 178027 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 104 Burrows St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011081.26767 | 2093487.71091 | 37.7289433454513 | -122.403949545331 | (37.7289433454513, -122.403949545331) | 10 | 3 | 7 | 309 | 28 | |||
45037 | 232990 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1043 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998833.08221 | 2106296.55498 | 37.7634214173918 | -122.447213725654 | (37.7634214173918, -122.447213725654) | 15 | 5 | 11 | 29492 | 9 | |||
69932 | 56849 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1043 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | Permit Number 14083 | 5998828.52357861 | 2106301.56148098 | 37.7634349035124 | -122.447229852767 | (37.7634349035124, -122.447229852767) | 15 | 5 | 11 | 29492 | 9 | |||
177489 | 232922 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1044 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004379.7073 | 2102801.65271 | 37.7541406099171 | -122.427780701834 | (37.7541406099171, -122.427780701834) | 2 | 4 | 5 | 28862 | 22 | |||
187994 | 232923 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1044 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004380.50848 | 2102786.98314 | 37.7541003760405 | -122.427776885991 | (37.7541003760405, -122.427776885991) | 2 | 4 | 5 | 28862 | 22 | |||
85552 | 210653 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 105 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992494.33571 | 2098391.50751 | 37.7413519761053 | -122.468562012235 | (37.7413519761053, -122.468562012235) | 1 | 8 | 4 | 59 | 40 | |||
183440 | 233203 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 105 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008326.36502 | 2098049.92263 | 37.7413158872061 | -122.413796054251 | (37.7413158872061, -122.413796054251) | 2 | 7 | 7 | 28859 | 2 | |||
188980 | 210675 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 105 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5994239.22716 | 2095898.63187 | 37.7346077982181 | -122.462348069202 | (37.7346077982181, -122.462348069202) | 9 | 8 | 4 | 59 | 40 | |||
192072 | 210676 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 105 Maywood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5994232.52898 | 2095915.26292 | 37.7346530772751 | -122.46237243275 | (37.7346530772751, -122.46237243275) | 9 | 8 | 4 | 59 | 40 | |||
93101 | 251659 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 1050 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
143771 | 251658 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 1050 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
39906 | 233027 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1050 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007577.65197 | 2103596.17277 | 37.7565025650535 | -122.41677768004 | (37.7565025650535, -122.41677768004) | 2 | 4 | 7 | 28859 | 19 | |||
80353 | 39179 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1050 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1998 12:00:00 AM | 9 | Permit Number 40838 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | 2 | 4 | 7 | 28859 | 19 | ||
50323 | 26701 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1055 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2002 12:00:00 AM | 3 | 3X3 | 6004445.56166 | 2102766.22763 | 37.7540470660247 | -122.427550437605 | (37.7540470660247, -122.427550437605) | 2 | 4 | 5 | 28862 | 22 | ||
92459 | 132015 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1059 Vallejo St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6008494.23217 | 2118613.42416 | 37.797787882574 | -122.414670507348 | (37.797787882574, -122.414670507348) | 5 | 1 | 10 | 308 | 21 | ||||
190725 | 132014 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1059 Vallejo St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6008488.51458 | 2118614.01673 | 37.797789188388 | -122.414690333816 | (37.797789188388, -122.414690333816) | 5 | 1 | 10 | 308 | 21 | ||||
100457 | 1984 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 106 Bertha Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/1997 12:00:00 AM | 3 | 3X4 | 6017854.9793307 | 2094779.8205714 | 37.732867343787 | -122.380621861717 | (37.732867343787, -122.380621861717) | 10 | 3 | 8 | 58 | 1 | ||
26445 | 138269 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 106 Blake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997877.2646 | 2112995.6821 | 37.7817608358344 | -122.451002677666 | (37.7817608358344, -122.451002677666) | 15 | 6 | 2 | 54 | 16 | |||
175394 | 248370 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 107 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5998216.6849 | 2108153.1367 | 37.7684838810387 | -122.449479417032 | (37.7684838810387, -122.449479417032) | 15 | 5 | 11 | 29492 | 9 | |||
24835 | 233004 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 107 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008863.5869 | 2098014.91089 | 37.7412499075619 | -122.411936049411 | (37.7412499075619, -122.411936049411) | 10 | 7 | 7 | 28859 | 2 | |||
149363 | 132013 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1070 Vallejo St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6008438.12882 | 2118657.35642 | 37.7979053574127 | -122.41486775204 | (37.7979053574127, -122.41486775204) | 5 | 1 | 10 | 308 | 21 | |||
97072 | 233179 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1072 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998990.94366 | 2106256.22808 | 37.7633197085617 | -122.446664834323 | (37.7633197085617, -122.446664834323) | 15 | 5 | 5 | 29492 | 9 | |||
21727 | 108687 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1076 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2014 12:00:00 AM | 3 | Permit Number 773107 | 6012169.21632 | 2103384.10466 | 37.7561774592463 | -122.400883423742 | (37.7561774592463, -122.400883423742) | 10 | 3 | 8 | 28856 | 29 | |
60988 | 194221 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1080 Key Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 6012968.46094 | 2090076.8184 | 37.7196829822717 | -122.397186255957 | (37.7196829822717, -122.397186255957) | 10 | 3 | 8 | 58 | 1 | |||
130480 | 194223 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1080 Key Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6012938.89979 | 2090098.87174 | 37.7197418905657 | -122.397289984657 | (37.7197418905657, -122.397289984657) | 10 | 3 | 8 | 58 | 1 | |||
187048 | 194222 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1080 Key Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6012957.45228 | 2090084.12895 | 37.7197024427026 | -122.397224821584 | (37.7197024427026, -122.397224821584) | 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) );