trees
7,322 rows where qSpecies_id = 1 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
310 | 218546 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 5 | : | Tree | Private 2 | 7 | Width 3ft | 5991216.07157 | 2094485.7269 | 37.730553771324 | -122.472697049151 | (37.730553771324, -122.472697049151) | 9 | 8 | 4 | 64 | 40 | |||
411 | 247779 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 254 30th St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6004930.81683 | 2098452.72536 | 37.7422306182373 | -122.42556533529 | (37.7422306182373, -122.42556533529) | 2 | 7 | 5 | 63 | 22 | |||
3132 | 241639 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 200 Guerrero St | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6005424.1713 | 2107755.72538 | 37.7678023541299 | -122.424521053307 | (37.7678023541299, -122.424521053307) | 8 | 4 | 5 | 28853 | 19 | |||
6219 | 198125 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 75 Williams Ave | 5 | : | Tree | Private 2 | 9 | Width 3ft | 6013825.74476 | 2093610.04486 | 37.72943220072 | -122.394470179266 | (37.72943220072, -122.394470179266) | 10 | 3 | 8 | 58 | 1 | |||
10610 | 218537 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 169 Eucalyptus Dr | 2 | : | Tree | Private 2 | 3 | Width 2ft | 5991155.07657 | 2094656.4445 | 37.7310189879395 | -122.472920359789 | (37.7310189879395, -122.472920359789) | 9 | 8 | 4 | 64 | 40 | |||
11000 | 241648 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Scott St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6002449.19089 | 2108391.942 | 37.7693807938253 | -122.434856646815 | (37.7693807938253, -122.434856646815) | 15 | 5 | 5 | 29492 | 9 | |||
13294 | 85220 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 603 22nd Ave | 3 | : | Tree | Private 2 | 07/19/2007 12:00:00 AM | 3 | Permit Number 49541 | 5989076.71677 | 2111162.9995 | 37.7762210417533 | -122.481313842154 | (37.7762210417533, -122.481313842154) | 11 | 6 | 2 | 55 | 26 | ||
17112 | 198009 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 275 Shipley St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6011338.42729 | 2111564.35079 | 37.7785921853276 | -122.404332338179 | (37.7785921853276, -122.404332338179) | 14 | 2 | 9 | 28856 | 34 | |||
17243 | 218510 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 330 Lakeview Ave | 1 | : | Tree | Private 2 | 07/25/2000 12:00:00 AM | 7 | Width 3ft | Permit Number 43360 | 5996781.43157 | 2089689.53525 | 37.7177051527504 | -122.453110785357 | (37.7177051527504, -122.453110785357) | 9 | 8 | 6 | 28861 | 24 | |
17587 | 247758 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 89 Alpine Ter | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6001675.24031 | 2108330.55722 | 37.7691682741178 | -122.43752930513 | (37.7691682741178, -122.43752930513) | 15 | 5 | 5 | 29492 | 9 | |||
20217 | 218570 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Rossmoor Dr | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5990761.96187 | 2094481.85885 | 37.7305168532543 | -122.47426667546 | (37.7305168532543, -122.47426667546) | 9 | 8 | 4 | 64 | 40 | |||
20554 | 218572 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Rossmoor Dr | 3 | : | Tree | Private 2 | 6 | Width 3ft | 5990712.73892 | 2094463.91628 | 37.7304647357382 | -122.474435535782 | (37.7304647357382, -122.474435535782) | 9 | 8 | 4 | 64 | 40 | |||
20919 | 218547 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 4 | : | Tree | Private 2 | 6 | Width 3ft | 5991211.41676 | 2094496.23075 | 37.7305823428046 | -122.472713906928 | (37.7305823428046, -122.472713906928) | 9 | 8 | 4 | 64 | 40 | |||
21380 | 198142 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1655 Jerrold Ave | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6015037.63541 | 2097187.27801 | 37.7393218528083 | -122.390530383376 | (37.7393218528083, -122.390530383376) | 10 | 3 | 8 | 58 | 1 | |||
21605 | 198026 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 370 07th St | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6010608.77532 | 2110557.14149 | 37.7757858229832 | -122.406785493561 | (37.7757858229832, -122.406785493561) | 8 | 2 | 9 | 28853 | 34 | |||
21721 | 241240 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1301 Jessie St | 5 | : | Tree | Private 2 | 7 | Width 2ft | 6006461.32072 | 2109025.58866 | 37.7713476129226 | -122.421023844381 | (37.7713476129226, -122.421023844381) | 8 | 2 | 9 | 28853 | 19 | |||
21781 | 198037 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 157 12th St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6007615.86414 | 2109193.62258 | 37.7718740085958 | -122.417042123 | (37.7718740085958, -122.417042123) | 8 | 2 | 9 | 28853 | 19 | |||
22761 | 198121 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Venus St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6012854.74593 | 2094309.46046 | 37.731298624935 | -122.397876080041 | (37.731298624935, -122.397876080041) | 10 | 3 | 8 | 58 | 1 | |||
23354 | 218521 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 569 Victoria St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5993243.83162 | 2090944.13294 | 37.7209465926795 | -122.465429665468 | (37.7209465926795, -122.465429665468) | 9 | 8 | 6 | 64 | 24 | |||
26181 | 218506 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 331 Tara St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5997624.73798 | 2089991.46593 | 37.7185824800643 | -122.450217619562 | (37.7185824800643, -122.450217619562) | 9 | 8 | 6 | 28861 | 24 | |||
27518 | 218549 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5991185.28543 | 2094512.38991 | 37.7306251990928 | -122.472805423756 | (37.7306251990928, -122.472805423756) | 9 | 8 | 4 | 64 | 40 | |||
28343 | 198108 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1606 20th St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6013167.45896 | 2104762.27633 | 37.7600172487192 | -122.397527790602 | (37.7600172487192, -122.397527790602) | 10 | 3 | 8 | 28856 | 29 | |||
28597 | 218514 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 312 Vernon St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992482.71781 | 2089883.86567 | 37.7179914312497 | -122.467983503544 | (37.7179914312497, -122.467983503544) | 9 | 8 | 6 | 64 | 24 | |||
28921 | 198019 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 215 Clara St | 4 | : | Tree | Private 2 | 1 | Width 3ft | 6011790.16995 | 2111731.99021 | 37.7790777176076 | -122.402781370989 | (37.7790777176076, -122.402781370989) | 14 | 2 | 9 | 28856 | 34 | |||
30365 | 241231 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 243 Duboce Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6005149.29633 | 2108406.92358 | 37.7695748612069 | -122.425518164045 | (37.7695748612069, -122.425518164045) | 8 | 4 | 5 | 28853 | 19 | |||
30709 | 218559 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 65 Rossmoor Dr | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5990923.4815 | 2094514.63427 | 37.7306162022607 | -122.473710674116 | (37.7306162022607, -122.473710674116) | 9 | 8 | 4 | 64 | 40 | |||
31306 | 218523 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 506 Victoria St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5993270.87957 | 2090565.64136 | 37.7199089063619 | -122.465308690447 | (37.7199089063619, -122.465308690447) | 9 | 8 | 6 | 64 | 24 | |||
32111 | 241252 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 186 Duboce Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6005533.12173 | 2108500.77585 | 37.7698542365083 | -122.424197200244 | (37.7698542365083, -122.424197200244) | 8 | 4 | 5 | 28853 | 19 | |||
32166 | 246604 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Waller St | 6 | : | Tree | Private 2 | 1 | Width 4ft | 6005614.48903 | 2109249.34773 | 37.7719142289884 | -122.423968991887 | (37.7719142289884, -122.423968991887) | 7 | 9 | 5 | 28852 | 10 | |||
32685 | 218538 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 167 Eucalyptus Dr | 1 | : | Tree | Private 2 | 3 | Width 2ft | 5991172.6444 | 2094656.25325 | 37.7310194798585 | -122.47285961148 | (37.7310194798585, -122.47285961148) | 9 | 8 | 4 | 64 | 40 | |||
34722 | 241250 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1360 Stevenson St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6006263.02031 | 2108761.78167 | 37.7706120817211 | -122.421691035237 | (37.7706120817211, -122.421691035237) | 8 | 2 | 9 | 28853 | 19 | |||
34985 | 198017 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 950 Clara St | 6 | : | Tree | Private 2 | 3 | Width 2ft | 6011612.66203 | 2111564.03025 | 37.7786066257438 | -122.403383627176 | (37.7786066257438, -122.403383627176) | 14 | 2 | 9 | 28856 | 34 | |||
35499 | 241644 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 415 Oak St | 1 | : | Tree | Private 2 | 5 | Width 5ft | 6004982.83626 | 2110199.46219 | 37.7744873314449 | -122.426221580476 | (37.7744873314449, -122.426221580476) | 7 | 9 | 11 | 28852 | 10 | |||
36112 | 180226 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2901 Ocean Ave | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5989906.43638 | 2095240.30742 | 37.7325497599557 | -122.477279727184 | (37.7325497599557, -122.477279727184) | 1 | 8 | 4 | 64 | 35 | |||
36118 | 241244 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1320 Stevenson St | 3 | : | Tree | Private 2 | 4 | Width 2ft | 6006253.43644 | 2109037.09804 | 37.771367494246 | -122.421743744473 | (37.771367494246, -122.421743744473) | 8 | 2 | 9 | 28853 | 19 | |||
36127 | 198119 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2651 Phelps St | 1 | : | Tree | Private 2 | 7 | Width 4ft | 6011866.47765 | 2093370.63046 | 37.728665704947 | -122.401226776815 | (37.728665704947, -122.401226776815) | 10 | 3 | 8 | 58 | 1 | |||
36347 | 241230 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 249 Duboce Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6005133.32674 | 2108406.69443 | 37.7695733296873 | -122.425573386006 | (37.7695733296873, -122.425573386006) | 8 | 4 | 5 | 28853 | 19 | |||
36355 | 218565 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 77 Rossmoor Dr | 2 | : | Tree | Private 2 | 8 | Width 3ft | 5990819.81522 | 2094485.38355 | 37.7305298826274 | -122.474066927066 | (37.7305298826274, -122.474066927066) | 9 | 8 | 4 | 64 | 40 | |||
36485 | 241647 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Scott St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6002452.37921 | 2108374.66361 | 37.7693335326385 | -122.434844382773 | (37.7693335326385, -122.434844382773) | 15 | 5 | 5 | 29492 | 9 | |||
37420 | 241246 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1320 Stevenson St | 6 | : | Tree | Private 2 | 3 | Width 2ft | 6006255.64732 | 2108972.7216 | 37.7711908566085 | -122.421731523606 | (37.7711908566085, -122.421731523606) | 8 | 2 | 9 | 28853 | 19 | |||
37937 | 198013 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 950 Clara St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6011579.13499 | 2111530.21874 | 37.7785119145419 | -122.403497231313 | (37.7785119145419, -122.403497231313) | 14 | 2 | 9 | 28856 | 34 | |||
39327 | 198136 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 27 Bridgeview Dr | 1 | : | Tree | Private 2 | 12 | Width 2ft | 6014000.75949 | 2095429.88989 | 37.7344388515748 | -122.393992476471 | (37.7344388515748, -122.393992476471) | 10 | 3 | 8 | 58 | 1 | |||
41175 | 250638 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2609 Lake St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5987350.36914 | 2114602.8431 | 37.7855653557873 | -122.487538422371 | (37.7855653557873, -122.487538422371) | 11 | 6 | 1 | 55 | 33 | |||
41269 | 241234 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 55 Duboce Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6006307.19682 | 2108475.99911 | 37.7698298819675 | -122.421517928318 | (37.7698298819675, -122.421517928318) | 8 | 4 | 7 | 28853 | 19 | |||
43807 | 218507 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 19 Caine Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5997670.25765 | 2089705.91413 | 37.7178010258677 | -122.450039707591 | (37.7178010258677, -122.450039707591) | 9 | 8 | 6 | 28861 | 24 | |||
43839 | 247801 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 462 30th St | 1 | : | Tree | Private 2 | 12/05/1987 12:00:00 AM | 8 | Width 3ft | Permit Number 24911 | 6003630.84189 | 2098375.23957 | 37.7419443208891 | -122.430054719445 | (37.7419443208891, -122.430054719445) | 2 | 7 | 5 | 63 | 22 | |
44146 | 218552 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 70 Elmhurst Dr | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5991136.37193 | 2094544.36551 | 37.730710164332 | -122.472976854295 | (37.730710164332, -122.472976854295) | 9 | 8 | 4 | 64 | 40 | |||
44630 | 198122 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 75 Williams Ave | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6013771.43179 | 2093619.46536 | 37.7294550480043 | -122.394658605233 | (37.7294550480043, -122.394658605233) | 10 | 3 | 8 | 58 | 1 | |||
44714 | 250811 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 55 Sea View Ter | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5986145.66751 | 2114125.50365 | 37.7841843856539 | -122.491671129117 | (37.7841843856539, -122.491671129117) | 11 | 6 | 1 | 55 | 33 | |||
45299 | 180228 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2901 Ocean Ave | 4 | : | Tree | Private 2 | 5 | Width 3ft | 5989943.87272 | 2095241.7603 | 37.7325559212225 | -122.477150408276 | (37.7325559212225, -122.477150408276) | 1 | 8 | 4 | 64 | 35 | |||
46252 | 202322 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 149 Orsi Cir | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6012943.58757 | 2093025.90325 | 37.7277791874583 | -122.39747895112 | (37.7277791874583, -122.39747895112) | 10 | 3 | 8 | 58 | 1 | |||
46580 | 198115 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 500 Toland St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6012572.24129 | 2098849.51004 | 37.7437489121962 | -122.399171325003 | (37.7437489121962, -122.399171325003) | 10 | 3 | 8 | 58 | 1 | |||
46906 | 202309 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 180 Orsi Cir | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6013023.13823 | 2092919.35878 | 37.7274910671365 | -122.397196473155 | (37.7274910671365, -122.397196473155) | 10 | 3 | 8 | 58 | 1 | |||
46937 | 198110 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 500 Arkansas St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6012942.32537 | 2104667.31063 | 37.7597439555289 | -122.398299761419 | (37.7597439555289, -122.398299761419) | 10 | 3 | 8 | 28856 | 29 | |||
47073 | 198129 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 Apollo St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6013057.33243 | 2094752.72387 | 37.7325270152047 | -122.397206767679 | (37.7325270152047, -122.397206767679) | 10 | 3 | 8 | 58 | 1 | |||
47671 | 201529 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 718 Innes Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6020227.99181 | 2093752.40727 | 37.7301769329099 | -122.372346575457 | (37.7301769329099, -122.372346575457) | 10 | 3 | 8 | 58 | 1 | |||
48469 | 198139 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150 Bridgeview Dr | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6013283.18276 | 2095780.0515 | 37.7353604156587 | -122.396497929253 | (37.7353604156587, -122.396497929253) | 10 | 3 | 8 | 58 | 1 | |||
48870 | 217807 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 199 Lee Ave | 2 | : | Tree | Private 2 | 3 | Width 3ft | 5996526.25885 | 2091883.77807 | 37.7237153993246 | -122.454151192149 | (37.7237153993246, -122.454151192149) | 9 | 7 | 4 | 28861 | 40 | |||
50127 | 241239 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 McCoppin St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6005928.36777 | 2109150.09439 | 37.7716594186857 | -122.422876205876 | (37.7716594186857, -122.422876205876) | 8 | 2 | 9 | 28853 | 19 | |||
50962 | 180222 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3602 Alemany Blvd | 5 | : | Tree | Private 2 | 4 | Width 3ft | 5993369.41698 | 2087618.43257 | 37.7118222600726 | -122.464754174762 | (37.7118222600726, -122.464754174762) | 9 | 8 | 4 | 64 | 24 | |||
51712 | 241238 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 McCoppin St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6005908.08699 | 2109147.66491 | 37.7716516035611 | -122.422946185717 | (37.7716516035611, -122.422946185717) | 8 | 2 | 9 | 28853 | 19 | |||
52722 | 198140 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 152 Bridgeview Dr | 1 | : | Tree | Private 2 | 12 | Width 2ft | 6013267.76129 | 2095794.59184 | 37.7353994821874 | -122.396552266301 | (37.7353994821874, -122.396552266301) | 10 | 3 | 8 | 58 | 1 | |||
54865 | 218536 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 169 Eucalyptus Dr | 1 | : | Tree | Private 2 | 3 | Width 2ft | 5991140.50833 | 2094657.00485 | 37.7310196831058 | -122.472970765015 | (37.7310196831058, -122.472970765015) | 9 | 8 | 4 | 64 | 40 | |||
56039 | 198145 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1790 Newcomb Ave | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6014228.28626 | 2096474.50405 | 37.7373197901822 | -122.393278910306 | (37.7373197901822, -122.393278910306) | 10 | 3 | 8 | 58 | 1 | |||
56300 | 241247 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1330 Stevenson St | 2 | : | Tree | Private 2 | 5 | Width 2ft | 6006254.50183 | 2108932.02318 | 37.77107904388 | -122.421732594687 | (37.77107904388, -122.421732594687) | 8 | 2 | 9 | 28853 | 19 | |||
56930 | 198020 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 217 Clara St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011870.90395 | 2111808.74197 | 37.7792929676258 | -122.402507476166 | (37.7792929676258, -122.402507476166) | 14 | 2 | 9 | 28856 | 34 | |||
57055 | 198007 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 274 Shipley St | 2 | : | Tree | Private 2 | 1 | Width 2ft | 6011297.08858 | 2111564.84003 | 37.7785912185545 | -122.404475379844 | (37.7785912185545, -122.404475379844) | 14 | 2 | 9 | 28856 | 34 | |||
57693 | 198038 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 157 12th St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6007603.04686 | 2109200.86421 | 37.7718931713742 | -122.4170869722 | (37.7718931713742, -122.4170869722) | 8 | 2 | 9 | 28853 | 19 | |||
59851 | 198120 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1715 Silver Ave | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6011096.26048 | 2095120.58904 | 37.7334277240045 | -122.404012578842 | (37.7334277240045, -122.404012578842) | 10 | 3 | 8 | 58 | 1 | |||
60253 | 218556 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Rossmoor Dr | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5991013.46606 | 2094544.76676 | 37.7307041496708 | -122.473401783982 | (37.7307041496708, -122.473401783982) | 9 | 8 | 4 | 64 | 40 | |||
61027 | 180221 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 248 Wilson St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5994358.2246 | 2086656.84176 | 37.7092389170082 | -122.461266945616 | (37.7092389170082, -122.461266945616) | 9 | 8 | 6 | 28861 | 25 | |||
62195 | 198036 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 333 11th St | 4 | : | Tree | Private 2 | 3 | Width 3ft | 6008686.77489 | 2109006.56148 | 37.7714205668302 | -122.413324523514 | (37.7714205668302, -122.413324523514) | 8 | 2 | 9 | 28853 | 34 | |||
62429 | 218555 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Rossmoor Dr | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5991088.47089 | 2094414.70645 | 37.7303513798138 | -122.473133001812 | (37.7303513798138, -122.473133001812) | 9 | 8 | 4 | 64 | 40 | |||
62814 | 218513 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 234 Ralston St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 5992216.02262 | 2089433.07464 | 37.71673826375 | -122.468872558017 | (37.71673826375, -122.468872558017) | 9 | 8 | 6 | 64 | 24 | |||
63276 | 250810 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 55 Sea View Ter | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5986123.50864 | 2114127.60677 | 37.784188865162 | -122.491747944716 | (37.784188865162, -122.491747944716) | 11 | 6 | 1 | 55 | 33 | |||
63789 | 241248 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1346 Stevenson St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6006262.59994 | 2108856.22438 | 37.7708713751436 | -122.421699198355 | (37.7708713751436, -122.421699198355) | 8 | 2 | 9 | 28853 | 19 | |||
63997 | 198030 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 70 Converse St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6010334.07948 | 2109275.93485 | 37.7722525530475 | -122.407645384826 | (37.7722525530475, -122.407645384826) | 14 | 2 | 9 | 28853 | 34 | |||
64081 | 198028 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 106 Langton St | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6010225.17287 | 2110701.2793 | 37.7761601208299 | -122.40812264516 | (37.7761601208299, -122.40812264516) | 8 | 2 | 9 | 28853 | 34 | |||
64414 | 198031 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 354 09th St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6009423.88038 | 2109239.73963 | 37.7721021764946 | -122.4107912997 | (37.7721021764946, -122.4107912997) | 8 | 2 | 9 | 28853 | 34 | |||
64693 | 218519 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 313 Vernon St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5992450.27493 | 2089919.88933 | 37.7180884698913 | -122.468098262426 | (37.7180884698913, -122.468098262426) | 9 | 8 | 6 | 64 | 24 | |||
65157 | 241558 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 184 Marview Way | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5998169.83766 | 2103394.06931 | 37.7554139986847 | -122.449298535803 | (37.7554139986847, -122.449298535803) | 1 | 5 | 4 | 63 | 38 | |||
65360 | 218517 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 312 Vernon St | 4 | : | Tree | Private 2 | 8 | Width 3ft | 5992480.50725 | 2089942.05424 | 37.7181510752812 | -122.46799537461 | (37.7181510752812, -122.46799537461) | 9 | 8 | 6 | 64 | 24 | |||
69460 | 241251 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 156 Duboce Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6005676.56788 | 2108505.95935 | 37.7698765675662 | -122.4237013914 | (37.7698765675662, -122.4237013914) | 8 | 4 | 5 | 28853 | 19 | |||
69774 | 241637 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 200 Guerrero St | 3 | : | Tree | Private 2 | 4 | Width 2ft | 6005427.25297 | 2107715.69436 | 37.7676926125496 | -122.424507546383 | (37.7676926125496, -122.424507546383) | 8 | 4 | 5 | 28853 | 19 | |||
70140 | 180220 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 254 Wilson St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5994253.3591 | 2086751.7904 | 37.7094935879269 | -122.461636254036 | (37.7094935879269, -122.461636254036) | 9 | 8 | 6 | 28861 | 25 | |||
70255 | 198040 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 157 12th St | 4 | : | Tree | Private 2 | 4 | Width 3ft | 6007573.55961 | 2109215.4264 | 37.7719314968599 | -122.417190003036 | (37.7719314968599, -122.417190003036) | 8 | 2 | 9 | 28853 | 19 | |||
71772 | 198124 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 75 Williams Ave | 4 | : | Tree | Private 2 | 6 | Width 3ft | 6013810.98382 | 2093612.61282 | 37.7294384312212 | -122.394521389373 | (37.7294384312212, -122.394521389373) | 10 | 3 | 8 | 58 | 1 | |||
73477 | 198143 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1655 Jerrold Ave | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6015049.24886 | 2097178.829 | 37.7392992978216 | -122.390489638682 | (37.7392992978216, -122.390489638682) | 10 | 3 | 8 | 58 | 1 | |||
74270 | 218525 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 213 Bright St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 5993735.162 | 2088577.56083 | 37.7144768779817 | -122.463559632267 | (37.7144768779817, -122.463559632267) | 9 | 8 | 6 | 64 | 24 | |||
74652 | 198130 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 81 Topeka Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6012344.64179 | 2095362.18854 | 37.7341607757888 | -122.399713503797 | (37.7341607757888, -122.399713503797) | 10 | 3 | 8 | 58 | 1 | |||
74705 | 198106 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 878 Rhode Island St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6011838.88261 | 2104286.50365 | 37.7586368163639 | -122.40208927522 | (37.7586368163639, -122.40208927522) | 10 | 3 | 8 | 28856 | 29 | |||
75247 | 246469 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 274 Duncan St | 1 | : | Tree | Private 2 | 6 | Width 4ft | 6004738.49373 | 2099902.53955 | 37.7462006070647 | -122.426333530769 | (37.7462006070647, -122.426333530769) | 2 | 7 | 5 | 63 | 22 | |||
76290 | 202327 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 121 Orsi Cir | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6012845.23034 | 2093098.40434 | 37.7279727836132 | -122.397824059657 | (37.7279727836132, -122.397824059657) | 10 | 3 | 8 | 58 | 1 | |||
76942 | 247784 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300 30th St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6004564.02333 | 2098429.7737 | 37.7421468661792 | -122.426831960253 | (37.7421468661792, -122.426831960253) | 2 | 7 | 5 | 63 | 22 | |||
78116 | 246806 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 132 Brewster St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6010286.59808 | 2099166.12262 | 37.7444906190493 | -122.407096884714 | (37.7444906190493, -122.407096884714) | 2 | 7 | 7 | 28859 | 2 | |||
78231 | 198016 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 950 Clara St | 5 | : | Tree | Private 2 | 4 | Width 2ft | 6011600.73372 | 2111552.62558 | 37.7785746449277 | -122.403424089462 | (37.7785746449277, -122.403424089462) | 14 | 2 | 9 | 28856 | 34 | |||
78571 | 218531 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 179 Eucalyptus Dr | 3 | : | Tree | Private 2 | 3 | Width 2ft | 5990912.64325 | 2094665.20495 | 37.731029003689 | -122.473759123306 | (37.731029003689, -122.473759123306) | 9 | 8 | 4 | 64 | 40 | |||
79317 | 246450 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 425 Duncan St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6003711.71796 | 2099797.01906 | 37.7458527789913 | -122.429876467534 | (37.7458527789913, -122.429876467534) | 2 | 7 | 5 | 63 | 22 | |||
80366 | 180223 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3602 Alemany Blvd | 8 | : | Tree | Private 2 | 6 | Width 3ft | 5993236.04296 | 2087638.25257 | 37.7118689906411 | -122.465216587281 | (37.7118689906411, -122.465216587281) | 9 | 8 | 4 | 64 | 24 | |||
81370 | 256662 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1306 Broadway | : | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | Permit Number 782593 | 6007370.8774 | 2118134.97157 | 37.7964109931986 | -122.418523691035 | (37.7964109931986, -122.418523691035) | 5 | 1 | 10 | 28858 | 32 |
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) );