trees
3,709 rows where qSpecies_id = 9 sorted by DBH descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
137506 | 177991 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 287 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003887.60071 | 2091845.76575 | 37.7240303967739 | -122.428701577037 | (37.7240303967739, -122.428701577037) | 9 | 7 | 6 | 28861 | 5 | |||
137701 | 17738 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1335 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/1992 12:00:00 AM | 9 | 3X3 | 6002216.6 | 2113193.3325 | 37.7825510038819 | -122.4360047826 | (37.7825510038819, -122.4360047826) | 15 | 5 | 11 | 29490 | 41 | ||
141072 | 132037 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 647 Battery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6012462.86272 | 2118420.86653 | 37.7974813378361 | -122.400924323116 | (37.7974813378361, -122.400924323116) | 3 | 1 | 10 | 28860 | 4 | |||
141611 | 178031 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 233 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003049.4066 | 2092035.62613 | 37.7245042369626 | -122.431612630315 | (37.7245042369626, -122.431612630315) | 9 | 7 | 6 | 28861 | 5 | |||
146178 | 210814 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 486 Dewey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5994715.84856 | 2100034.45121 | 37.7459911648725 | -122.460999904532 | (37.7459911648725, -122.460999904532) | 1 | 8 | 4 | 29491 | 40 | |||
146610 | 137803 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1800 PINE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004934.2786 | 2115449.7152 | 37.7889004840658 | -122.426763522216 | (37.7889004840658, -122.426763522216) | 13 | 9 | 1 | 28858 | 27 | |||
147753 | 31491 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 21 Worth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | 9 | Permit Number 35054 | 6000892.09829 | 2103158.85451 | 37.7549234931482 | -122.439867288838 | (37.7549234931482, -122.439867288838) | 2 | 4 | 5 | 28862 | 22 | |
148557 | 233711 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4080 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002423.845 | 2104741.37896 | 37.7593557982383 | -122.434683239558 | (37.7593557982383, -122.434683239558) | 2 | 4 | 5 | 28862 | 3 | |||
149489 | 210862 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 412 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5999352.48487 | 2094990.83835 | 37.7324083217769 | -122.444604653878 | (37.7324083217769, -122.444604653878) | 9 | 7 | 4 | 59 | 40 | |||
150510 | 233150 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 590 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 6002973.47072 | 2095727.01739 | 37.7346356592157 | -122.432138621314 | (37.7346356592157, -122.432138621314) | 2 | 7 | 5 | 63 | 7 | |||
151248 | 131849 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3601 Baker St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 2ft | 5999142.98862 | 2121202.59701 | 37.8043672291134 | -122.447214717591 | (37.8043672291134, -122.447214717591) | 13 | 9 | 1 | 57 | 17 | |||
154313 | 55404 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 293 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1972 12:00:00 AM | 9 | Permit Number 11343 | 6011557.05341 | 2119721.55035 | 37.8010021324143 | -122.404150266829 | (37.8010021324143, -122.404150266829) | 3 | 1 | 10 | 308 | 23 | ||
154351 | 177972 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 32 Edinburgh St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 6004452.10301 | 2093339.7644 | 37.7281645190556 | -122.426856528812 | (37.7281645190556, -122.426856528812) | 9 | 7 | 6 | 28861 | 5 | |||
154981 | 232927 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 370 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004187.38096 | 2098992.907 | 37.7436717980285 | -122.428174395344 | (37.7436717980285, -122.428174395344) | 2 | 7 | 5 | 63 | 22 | |||
156780 | 232460 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1300 San Jose Ave | 11 | Front Yard : Yard | Tree | Private 2 | 9 | 6003616.28584 | 2095734.48892 | 37.734692598886 | -122.429916725697 | (37.734692598886, -122.429916725697) | 2 | 7 | 5 | 63 | 7 | ||||
157225 | 210592 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1260 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5992092.3928 | 2106837.96884 | 37.7645205364126 | -122.470566813334 | (37.7645205364126, -122.470566813334) | 11 | 8 | 11 | 56 | 12 | |||
157341 | 233825 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 20 Brady St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6006580.12185 | 2109628.40278 | 37.7730094926319 | -122.420655705111 | (37.7730094926319, -122.420655705111) | 8 | 2 | 9 | 28853 | 19 | |||
157691 | 131929 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 57 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008185.16924 | 2112536.59269 | 37.781085018795 | -122.415309543996 | (37.781085018795, -122.415309543996) | 7 | 10 | 9 | 28852 | 36 | |||
158202 | 66587 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 122 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1991 12:00:00 AM | 9 | Permit Number 29778 | 6004658.11486 | 2092667.31965 | 37.7263297806774 | -122.426096486574 | (37.7263297806774, -122.426096486574) | 9 | 7 | 6 | 28861 | 5 | |
159570 | 233735 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 608 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002999.05257 | 2104621.86014 | 37.7590602666344 | -122.432685355142 | (37.7590602666344, -122.432685355142) | 2 | 4 | 5 | 28862 | 3 | |||
159775 | 178041 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 215 Naylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002576.29387 | 2086830.58656 | 37.7101855209097 | -122.432876439519 | (37.7101855209097, -122.432876439519) | 9 | 7 | 6 | 28861 | 5 | |||
159864 | 194136 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301 Minnesota St | 51 | Front Yard : Yard | Tree | Private 2 | 9 | 6015363.67927 | 2102425.5673 | 37.7537231868853 | -122.389768841963 | (37.7537231868853, -122.389768841963) | 10 | 3 | 8 | 28856 | 29 | ||||
164370 | 177948 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Fuente Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989566.53985 | 2090511.453 | 37.7195457933774 | -122.478109206096 | (37.7195457933774, -122.478109206096) | 1 | 8 | 4 | 64 | 14 | ||||
164663 | 123927 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 237 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993041.35148 | 2113862.1057 | 37.7838617572526 | -122.467795559893 | (37.7838617572526, -122.467795559893) | 11 | 6 | 2 | 54 | 11 | |||
164845 | 56318 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 246 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1973 12:00:00 AM | 9 | Permit Number 12452 | 5993089.66375 | 2113819.3637 | 37.7837471889454 | -122.467625309376 | (37.7837471889454, -122.467625309376) | 11 | 6 | 2 | 54 | 11 | ||
165570 | 177960 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989129.76935 | 2089200.6687 | 37.7159213447791 | -122.479523094137 | (37.7159213447791, -122.479523094137) | 1 | 8 | 4 | 64 | 14 | ||||
167965 | 22457 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6150X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 6013494.5908 | 2091319.1743 | 37.7231235191025 | -122.395454590098 | (37.7231235191025, -122.395454590098) | 10 | 3 | 8 | 58 | 1 | ||||
172271 | 232887 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 78 Norwich St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6008973.99596 | 2099483.36484 | 37.7452881531218 | -122.411658023093 | (37.7452881531218, -122.411658023093) | 2 | 7 | 7 | 28859 | 2 | ||||
172274 | 132006 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2319 Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6007049.78322 | 2120303.77826 | 37.8023479084848 | -122.419788716402 | (37.8023479084848, -122.419788716402) | 5 | 1 | 1 | 28858 | 32 | |||
172290 | 131900 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3201 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5999404.71857 | 2115660.50969 | 37.7891650856388 | -122.445910141263 | (37.7891650856388, -122.445910141263) | 13 | 6 | 1 | 29490 | 31 | |||
173421 | 233692 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3926 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004321.37084 | 2101339.12009 | 37.7501215369861 | -122.427878236899 | (37.7501215369861, -122.427878236899) | 2 | 4 | 5 | 28862 | 22 | |||
173863 | 56284 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 346 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | 9 | Permit Number 12411 | 5992186.85006 | 2113105.16274 | 37.781734021746 | -122.470696637662 | (37.781734021746, -122.470696637662) | 11 | 6 | 2 | 54 | 11 | ||
173981 | 49805 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1142SSIPPI 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 9 | Permit Number 46600 | 6014194.88278 | 2105753.61687 | 37.7627964083541 | -122.394043799009 | (37.7627964083541, -122.394043799009) | 14 | 3 | 8 | 28856 | 29 | |
174237 | 43285 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 207 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 9 | 3x3 | Permit Number 43054 | 5997806.6351 | 2109857.0399 | 37.773138896488 | -122.451020622097 | (37.773138896488, -122.451020622097) | 15 | 5 | 11 | 29492 | 16 |
179671 | 14698 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 800 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 4X4 | 5999602.4544 | 2111254.5866 | 37.7770788509373 | -122.444909154071 | (37.7770788509373, -122.444909154071) | 15 | 5 | 11 | 29490 | 16 | |||
183912 | 11163 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2646 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6006947.21164 | 2121442.50233 | 37.8054687763153 | -122.420224530547 | (37.8054687763153, -122.420224530547) | 5 | 1 | 1 | 28858 | 32 | |||
186638 | 233631 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2412 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008814.85416 | 2104268.0424 | 37.7584168763487 | -122.412546472365 | (37.7584168763487, -122.412546472365) | 2 | 4 | 7 | 28859 | 19 | |||
187167 | 132022 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 928 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007892.79628 | 2120308.15692 | 37.8024073851468 | -122.416871780604 | (37.8024073851468, -122.416871780604) | 5 | 1 | 1 | 308 | 32 | |||
187554 | 124396 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3920 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5996009.83967 | 2115561.95106 | 37.7887000369005 | -122.457648792322 | (37.7887000369005, -122.457648792322) | 11 | 6 | 1 | 54 | 31 | |||
189213 | 210872 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 371 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5997627.30354 | 2093781.83319 | 37.7289900868006 | -122.450481853864 | (37.7289900868006, -122.450481853864) | 9 | 7 | 4 | 28861 | 40 | |||
189997 | 9192 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6138 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4X4 | 5987910.6661 | 2112635.8342 | 37.7801971691873 | -122.485455585501 | (37.7801971691873, -122.485455585501) | 11 | 6 | 2 | 55 | 26 | |||
191342 | 55286 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1259 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1972 12:00:00 AM | 9 | Permit Number 11212 | 5988298.2438 | 2106737.9903 | 37.7640258998421 | -122.483682252657 | (37.7640258998421, -122.483682252657) | 1 | 8 | 3 | 56 | 35 | ||
191402 | 210873 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 62 Marston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5998923.83927 | 2093227.89544 | 37.7275432251404 | -122.445959824297 | (37.7275432251404, -122.445959824297) | 9 | 7 | 4 | 28861 | 40 | |||
191976 | 232859 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 660 York St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009811.5773 | 2105096.24111 | 37.7607468102296 | -122.409157786424 | (37.7607468102296, -122.409157786424) | 2 | 4 | 8 | 28859 | 19 | |||
192497 | 122229 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 761 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5991623.94602 | 2110243.98291 | 37.7738454364146 | -122.472435352053 | (37.7738454364146, -122.472435352053) | 11 | 6 | 2 | 54 | 26 | |||
193701 | 210609 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1265 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994217.96426 | 2106915.76714 | 37.7648568297895 | -122.463220740766 | (37.7648568297895, -122.463220740766) | 11 | 5 | 11 | 56 | 12 | |||
194462 | 233115 | Prune Opt Out 3 | Olea europaea :: Olive Tree 9 | 29 Kronquist Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | Permit Number 788008 | 6002251.64499 | 2100180.50663 | 37.7468229532305 | -122.434952608978 | (37.7468229532305, -122.434952608978) | 2 | 7 | 5 | 63 | 22 | ||
269 | 194187 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1100 19th St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014241.14855 | 2105287.11165 | 37.7615180580268 | -122.393851124637 | (37.7615180580268, -122.393851124637) | 10 | 3 | 8 | 28856 | 29 | |||
2720 | 194183 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1100 19th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014273.14939 | 2105289.03804 | 37.7615251258084 | -122.393740580889 | (37.7615251258084, -122.393740580889) | 10 | 3 | 8 | 28856 | 29 | |||
2981 | 70375 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1590 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5983148.8552 | 2104320.0131 | 37.757085733924 | -122.501313312685 | (37.757085733924, -122.501313312685) | 1 | 8 | 3 | 56 | 35 | |||
3954 | 232446 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3742 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005626.63295 | 2100825.4971 | 37.7487850005374 | -122.423328051366 | (37.7487850005374, -122.423328051366) | 2 | 4 | 5 | 28859 | 19 | |||
4113 | 194123 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 963 Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007973 | 2110046 | 37.7742345191157 | -122.415867130014 | (37.7742345191157, -122.415867130014) | 8 | 2 | 9 | 28853 | 34 | |||
4203 | 72834 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6015894.43243 | 2105382.09889 | 37.7618706120468 | -122.388139674229 | (37.7618706120468, -122.388139674229) | 10 | 3 | 8 | 28856 | 29 | |||
7046 | 69901 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 607 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6002511.32191 | 2089559.78285 | 37.7176756091205 | -122.433295884208 | (37.7176756091205, -122.433295884208) | 9 | 7 | 6 | 28861 | 5 | |||
7404 | 210734 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 270 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992990.46687 | 2089001.91036 | 37.7155991032881 | -122.466164394482 | (37.7155991032881, -122.466164394482) | 9 | 8 | 6 | 64 | 24 | |||
8413 | 120008 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 700 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5986957.64552 | 2111044.59279 | 37.7757725016367 | -122.488635485438 | (37.7757725016367, -122.488635485438) | 11 | 6 | 2 | 55 | 26 | |||
9397 | 194190 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1120 19th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014220.74696 | 2105285.57644 | 37.7615127088737 | -122.393921578412 | (37.7615127088737, -122.393921578412) | 10 | 3 | 8 | 28856 | 29 | |||
11186 | 233023 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 377 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007268.08655 | 2096284.2929 | 37.7364083704527 | -122.417330125494 | (37.7364083704527, -122.417330125494) | 2 | 7 | 7 | 28859 | 2 | |||
11711 | 38775 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 660 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1998 12:00:00 AM | 8 | Permit Number 40638 | 6014484.21875 | 2111755.81993 | 37.7792932023544 | -122.393463157999 | (37.7792932023544, -122.393463157999) | 6 | 2 | 9 | 28856 | 34 | |
12136 | 137985 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2281 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003041.7191 | 2115135.3028 | 37.7879300034078 | -122.433289038266 | (37.7879300034078, -122.433289038266) | 13 | 9 | 11 | 29490 | 27 | |||
14636 | 55313 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1100 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 8 | 9x3 | Permit Number 11242 | 6011254.56702 | 2089617.4839 | 37.7183261795882 | -122.403078315405 | (37.7183261795882, -122.403078315405) | 10 | 7 | 8 | 309 | 39 | |
15702 | 66427 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/1991 12:00:00 AM | 8 | Permit Number 29569 | 6012980.71061 | 2090558.71757 | 37.7210068625643 | -122.397177686318 | (37.7210068625643, -122.397177686318) | 10 | 3 | 8 | 58 | 1 | ||
16693 | 58016 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 348 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/1977 12:00:00 AM | 8 | Permit Number 16983 | 6006792 | 2092833 | 37.7269050782636 | -122.41873147758 | (37.7269050782636, -122.41873147758) | 9 | 7 | 7 | 309 | 5 | ||
16977 | 140823 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 620 EUCLID AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5996399.8843 | 2113855.1043 | 37.7840358904974 | -122.456175846275 | (37.7840358904974, -122.456175846275) | 11 | 6 | 1 | 54 | 31 | |||
17500 | 37109 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301X 46th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981799.7427 | 2106129.159 | 37.7619738119048 | -122.506113117253 | (37.7619738119048, -122.506113117253) | 1 | 8 | 3 | 56 | 35 |
17711 | 42162 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1407 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 8 | Permit Number 42457 | 5991237.30182 | 2110614.79116 | 37.7748411888545 | -122.473799860621 | (37.7748411888545, -122.473799860621) | 11 | 6 | 2 | 54 | 26 | |
19520 | 37110 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301X 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981797.2694 | 2106191.6975 | 37.7621453791042 | -122.506126308526 | (37.7621453791042, -122.506126308526) | 1 | 8 | 3 | 56 | 35 |
19657 | 210850 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 32 Valletta Ct | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5999400.78562 | 2096662.25477 | 37.737000393259 | -122.444557752446 | (37.737000393259, -122.444557752446) | 9 | 7 | 4 | 63 | 40 | |||
20204 | 132002 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2347 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007031.64315 | 2120451.58082 | 37.8027527149307 | -122.419861984153 | (37.8027527149307, -122.419861984153) | 5 | 1 | 1 | 28858 | 32 | |||
21368 | 183749 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2275 28th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5987605.0718 | 2099820.1671 | 37.7449910546775 | -122.485571982913 | (37.7449910546775, -122.485571982913) | 1 | 8 | 3 | 29491 | 35 | |||
22242 | 37108 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301X 46th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981801.156 | 2106110.4328 | 37.7619224783225 | -122.506106840747 | (37.7619224783225, -122.506106840747) | 1 | 8 | 3 | 56 | 35 |
22646 | 114497 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 506 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6013500.00708 | 2111383.84435 | 37.7782171086788 | -122.396841893834 | (37.7782171086788, -122.396841893834) | 6 | 2 | 9 | 28856 | 34 | |||
23591 | 118179 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 725 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5985671.99476 | 2110951.2879 | 37.7754412063892 | -122.493075936947 | (37.7754412063892, -122.493075936947) | 11 | 6 | 2 | 55 | 26 | |||
23635 | 131926 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 811 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006096.41704 | 2112784.17992 | 37.7816472182901 | -122.422553190084 | (37.7816472182901, -122.422553190084) | 7 | 9 | 11 | 28852 | 41 | |||
24067 | 43048 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2159 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 8 | Permit Number 42902 | 5983545.7781 | 2100465.2765 | 37.7465249999307 | -122.499655734442 | (37.7465249999307, -122.499655734442) | 1 | 8 | 3 | 29491 | 35 | |
28684 | 131822 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3515 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997963.12776 | 2115785.79139 | 37.7894266552706 | -122.450906879748 | (37.7894266552706, -122.450906879748) | 11 | 6 | 1 | 54 | 31 | |||
29787 | 131877 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3533 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6002622.38757 | 2120752.94987 | 37.80333080903 | -122.435141800264 | (37.80333080903, -122.435141800264) | 13 | 9 | 1 | 57 | 17 | |||
33522 | 140025 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 619 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005803.6906 | 2111825.1954 | 37.7789975628417 | -122.423497687453 | (37.7789975628417, -122.423497687453) | 7 | 9 | 11 | 28852 | 41 | |||
33962 | 233693 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3930 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004287.58657 | 2101338.47985 | 37.7501178677493 | -122.427995019273 | (37.7501178677493, -122.427995019273) | 2 | 4 | 5 | 28862 | 22 | |||
34122 | 194169 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 760 San Bruno Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6010966.15576 | 2104754.45059 | 37.7598729443885 | -122.405140527417 | (37.7598729443885, -122.405140527417) | 10 | 3 | 8 | 28856 | 29 | ||||
36590 | 233783 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 10 Saturn St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000623.49703 | 2106025.63794 | 37.7627796854658 | -122.441001838469 | (37.7627796854658, -122.441001838469) | 15 | 5 | 5 | 28862 | 3 | |||
36779 | 138332 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2319 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002870.3255 | 2115114.7895 | 37.7878639544693 | -122.433880561554 | (37.7878639544693, -122.433880561554) | 13 | 9 | 11 | 29490 | 27 | |||
39238 | 233089 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4626 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000550.31 | 2101129.31391 | 37.7493314034324 | -122.440903700858 | (37.7493314034324, -122.440903700858) | 2 | 4 | 5 | 28862 | 22 | |||
40790 | 132019 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1116 Greenwich St | 2 | Front Yard : Yard | Tree | Private 2 | 8 | 6007503.17736 | 2119909.69915 | 37.8012913975493 | -122.41819179113 | (37.8012913975493, -122.41819179113) | 5 | 1 | 1 | 28858 | 32 | ||||
41186 | 233214 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 42 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007330.94999 | 2099246.41319 | 37.7445452321859 | -122.417322627862 | (37.7445452321859, -122.417322627862) | 2 | 7 | 7 | 28859 | 2 | |||
41508 | 233781 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 10 Saturn St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000622.86001 | 2106032.19557 | 37.7627976548176 | -122.441004512163 | (37.7627976548176, -122.441004512163) | 15 | 5 | 5 | 28862 | 3 | |||
46347 | 177891 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 350 Rutland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010352.02594 | 2088617.41992 | 37.7155297655706 | -122.406127617893 | (37.7155297655706, -122.406127617893) | 9 | 7 | 8 | 309 | 39 | |||
50093 | 12726 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1545 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/1997 12:00:00 AM | 8 | 3X3 | 5990597.92823 | 2114719.13629 | 37.7860735319683 | -122.476311431561 | (37.7860735319683, -122.476311431561) | 11 | 6 | 2 | 54 | 26 | ||
50786 | 131867 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2209 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6001253.87552 | 2119676.74684 | 37.8002980360796 | -122.439800368519 | (37.8002980360796, -122.439800368519) | 13 | 9 | 1 | 57 | 17 | |||
51734 | 194189 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1120 19th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014227.51606 | 2105285.95725 | 37.7615141306866 | -122.39389819336 | (37.7615141306866, -122.39389819336) | 10 | 3 | 8 | 28856 | 29 | |||
52330 | 57138 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 543 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | 8 | Permit Number 14411 | 6003683.02162 | 2090004.97184 | 37.7189644023697 | -122.429277574812 | (37.7189644023697, -122.429277574812) | 9 | 7 | 6 | 28861 | 5 | ||
52471 | 233219 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 9 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007282.53208 | 2099823.35941 | 37.7461266729033 | -122.417530929716 | (37.7461266729033, -122.417530929716) | 2 | 7 | 7 | 28859 | 2 | |||
52781 | 137726 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1951 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999818.7059 | 2111217.6986 | 37.7769899052255 | -122.444158423639 | (37.7769899052255, -122.444158423639) | 15 | 5 | 11 | 29492 | 16 | |||
53619 | 37128 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1501 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | 8 | 2x2 | Permit Number 39712 | 5981844.8018 | 2104832.4428 | 37.7584160519707 | -122.505861139063 | (37.7584160519707, -122.505861139063) | 1 | 8 | 3 | 56 | 35 | |
54767 | 31298 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1718 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | 8 | Permit Number 43850 | 5989075.352 | 2103610.9593 | 37.7554851201375 | -122.480765550046 | (37.7554851201375, -122.480765550046) | 1 | 8 | 3 | 56 | 35 | |
54847 | 249458 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201 Olive St | 3 | : | Tree | Private 2 | 8 | Width 4ft | 6006350.21001 | 2113701.7523 | 37.7841809619115 | -122.421740379236 | (37.7841809619115, -122.421740379236) | 7 | 9 | 11 | 28858 | 41 | |||
56001 | 177922 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Cambon Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5990625.84661 | 2089245.25322 | 37.7161305522573 | -122.474355255986 | (37.7161305522573, -122.474355255986) | 1 | 8 | 4 | 64 | 14 | |||
56554 | 232451 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3621 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005419.83753 | 2105448.44153 | 37.7614668560188 | -122.424371916049 | (37.7614668560188, -122.424371916049) | 2 | 4 | 5 | 28859 | 19 | |||
58055 | 210621 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1358 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993664.65933 | 2106245.23095 | 37.7629838225623 | -122.465085760203 | (37.7629838225623, -122.465085760203) | 1 | 8 | 11 | 56 | 12 | |||
58517 | 41206 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3720 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1999 12:00:00 AM | 8 | Permit Number 41913 | 5999654.61261 | 2121348.57822 | 37.8047972741475 | -122.445454709292 | (37.8047972741475, -122.445454709292) | 13 | 9 | 1 | 57 | 17 |
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) );