Data source: data.sfgov.org
This data as json, CSV (advanced)
qCareAssistant ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9678 | 9678 | 114134 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
9720 | 9720 | 173652 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 65 ZIRCON PL | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6002398.2 | 2098694.7 | 37.7427515964219 | -122.43433962698201 | (37.7427515964219, -122.434339626982) | |||||
10256 | 10256 | 173933 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 190 Beacon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003193.0 | 2097540.0 | 37.739626138558705 | -122.43150902083299 | (37.7396261385587, -122.431509020833) | |||||
13268 | 13268 | 187627 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 88 States St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001213.0 | 2106258.0 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | |||||
13276 | 13276 | 20799 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1792X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2017 10:19:00 AM | 3 | 5984829.6375693 | 2102999.3844439 | 37.7535582155387 | -122.49540321629601 | (37.7535582155387, -122.495403216296) | |||
13314 | 13314 | 187669 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 554 Valley St | 1 | Median : Yard 3 | Tree 1 | Private 1 | 6002324.0 | 2099197.0 | 37.7441265828549 | -122.434632098307 | (37.7441265828549, -122.434632098307) | |||||
16807 | 16807 | 106757 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 999 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 36 | 6013321.202330001 | 2089752.82506 | 37.718812992515105 | -122.395944254446 | (37.7188129925151, -122.395944254446) | |||
18889 | 18889 | 106642 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4540X 17TH ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5999139.0 | 2105833.0 | 37.762166086231204 | -122.446122313424 | (37.7621660862312, -122.446122313424) | ||||
20392 | 20392 | 106278 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | ||||
21779 | 21779 | 29598 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/31/2014 08:52:00 AM | 3 | 5991178.77498 | 2091110.6465200002 | 37.7212844823864 | -122.472580013151 | (37.7212844823864, -122.472580013151) | |||
23006 | 23006 | 5050 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 6001979.62541 | 2098516.88417 | 37.7422395880754 | -122.43577421703002 | (37.7422395880754, -122.43577421703) | ||||
23021 | 23021 | 5047 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 6002007.86459 | 2098449.21717 | 37.7420553943514 | -122.43567173476002 | (37.7420553943514, -122.43567173476) | ||||
23106 | 23106 | 5048 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 6002000.04243 | 2098472.35983 | 37.7421184943815 | -122.435700436623 | (37.7421184943815, -122.435700436623) | ||||
23130 | 23130 | 5046 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 6002013.964380001 | 2098440.0292 | 37.7420305128012 | -122.43564998647 | (37.7420305128012, -122.43564998647) | ||||
23272 | 23272 | 5052 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | 6001966.9976699995 | 2098545.79058 | 37.742318241009606 | -122.43581994754999 | (37.7423182410096, -122.43581994755) | ||||
23275 | 23275 | 5049 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 39 | 6001985.29603 | 2098499.31047 | 37.7421916569134 | -122.43575335275101 | (37.7421916569134, -122.435753352751) | ||||
23290 | 23290 | 5051 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 6001971.36584 | 2098533.18854 | 37.7422838868872 | -122.43580394232 | (37.7422838868872, -122.43580394232) | ||||
23514 | 23514 | 190971 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 42 | 6011272.24417 | 2104307.20268 | 37.7586620081736 | -122.40405043579099 | (37.7586620081736, -122.404050435791) | ||||
24493 | 24493 | 190983 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6016115.94828 | 2100251.3725900003 | 37.7477949890666 | -122.387015672733 | (37.7477949890666, -122.387015672733) | ||||
24565 | 24565 | 176109 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 520 Carter St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6005252.95246 | 2086362.20208 | 37.7090508894465 | -122.42359208063299 | (37.7090508894465, -122.423592080633) | ||||
24654 | 24654 | 190986 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6016149.69105 | 2100259.24355 | 37.747818469462 | -122.38689953970601 | (37.747818469462, -122.386899539706) | ||||
24947 | 24947 | 206807 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 11x Saint Francis Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5991689.221530001 | 2095992.9314700002 | 37.734719554257296 | -122.471171081279 | (37.7347195542573, -122.471171081279) | ||||
25090 | 25090 | 223699 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 72 | 6004901.063490001 | 2096745.81285 | 37.737542142145706 | -122.425546760699 | (37.7375421421457, -122.425546760699) | ||||
25143 | 25143 | 126422 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 71 MacOndray Ln | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | 6008381.99212 | 2119124.63634 | 37.7991852374601 | -122.415095094385 | (37.7991852374601, -122.415095094385) | ||||
25637 | 25637 | 190976 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6011280.21235 | 2104227.17617 | 37.758442718371704 | -122.404017246303 | (37.7584427183717, -122.404017246303) | ||||
26953 | 26953 | 223749 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5200x Diamond Heights Blvd | 33 | Median : Yard 3 | Tree 1 | DPW 2 | 52 | 6001564.8370199995 | 2098920.55277 | 37.743324397105 | -122.43723732135099 | (37.743324397105, -122.437237321351) | ||||
28068 | 28068 | 126421 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 957 Green St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | 6008400.762999999 | 2118955.03362 | 37.7987206054154 | -122.415018129477 | (37.7987206054154, -122.415018129477) | ||||
30020 | 30020 | 218148 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 Ashton Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 25 | 5994122.86099 | 2090034.3755400002 | 37.7184992748049 | -122.462325196761 | (37.7184992748049, -122.462325196761) | ||||
30126 | 30126 | 223714 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 82 | Front Yard : Yard 7 | Tree 1 | Private 1 | 34 | 6004606.42672 | 2096213.68372 | 37.736064383369396 | -122.42652758019699 | (37.7360643833694, -122.426527580197) | ||||
30529 | 30529 | 102468 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 50 Saint Germain Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5998217.7 | 2104179.8 | 37.757574157371295 | -122.44918961776699 | (37.7575741573713, -122.449189617767) | |||||
31808 | 31808 | 217840 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Cranleigh Dr | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 5991415.56175 | 2095863.71205 | 37.7343489175724 | -122.47210779175501 | (37.7343489175724, -122.472107791755) | ||||
32031 | 32031 | 190995 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 10x Cashmere St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6017237.22965 | 2095860.87095 | 37.7358015834667 | -122.38283280631599 | (37.7358015834667, -122.382832806316) | ||||
32368 | 32368 | 190972 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6011274.67248 | 2104298.88872 | 37.758639315564 | -122.404041452454 | (37.758639315564, -122.404041452454) | ||||
33033 | 33033 | 223700 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6004786.16622 | 2096652.60405 | 37.7372797190785 | -122.42593738210199 | (37.7372797190785, -122.425937382102) | ||||
34240 | 34240 | 247903 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 582 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6009830.823 | 2098729.7061900003 | 37.743266798225605 | -122.40864208815701 | (37.7432667982256, -122.408642088157) | ||||
34710 | 34710 | 223715 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1101 San Jose Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6004750.57812 | 2096360.89303 | 37.736476735096296 | -122.426039666491 | (37.7364767350963, -122.426039666491) | ||||
35115 | 35115 | 126414 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2836 Larkin St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6006501.05561 | 2120998.5397099997 | 37.804224619123296 | -122.421736962694 | (37.8042246191233, -122.421736962694) | ||||
35184 | 35184 | 190969 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 6011271.58164 | 2104330.23228 | 37.758725205314704 | -122.404054347838 | (37.7587252053147, -122.404054347838) | ||||
35196 | 35196 | 223693 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 6004632.33856 | 2096219.1037400002 | 37.736080730338394 | -122.426438378246 | (37.7360807303384, -122.426438378246) | ||||
35448 | 35448 | 176098 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 184 Mount Vernon Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5998949.65718 | 2089392.42013 | 37.717013369950706 | -122.44559487852699 | (37.7170133699507, -122.445594878527) | ||||
35718 | 35718 | 223696 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1001 San Jose Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6005111.39586 | 2096784.72517 | 37.7376608688401 | -122.42482230911999 | (37.7376608688401, -122.42482230912) | ||||
35760 | 35760 | 223799 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 8 Laidley St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | 6003000.19412 | 2098305.51493 | 37.741717135947205 | -122.43223031618601 | (37.7417171359472, -122.432230316186) | ||||
35815 | 35815 | 249711 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2901 Broadway | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 5999592.84448 | 2116997.53125 | 37.7928469352999 | -122.44535542411501 | (37.7928469352999, -122.445355424115) | ||||
38291 | 38291 | 223754 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3980 22nd St | 4 | : 4 | Tree 1 | Private 1 | 8 | 6001944.38394 | 2102944.60727 | 37.754395065001795 | -122.436212863153 | (37.7543950650018, -122.436212863153) | ||||
39373 | 39373 | 206819 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2187x 09th Ave | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 5993645.71889 | 2101030.10757 | 37.7486633474324 | -122.46477253084 | (37.7486633474324, -122.46477253084) | ||||
39647 | 39647 | 190975 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 6011275.59974 | 2104245.89235 | 37.758493851126296 | -122.40403451598 | (37.7584938511263, -122.40403451598) | ||||
40050 | 40050 | 176160 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5990378.89561 | 2089837.21304 | 37.7177416175535 | -122.47525201947701 | (37.7177416175535, -122.475252019477) | ||||
40086 | 40086 | 190990 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 301x Cashmere St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6016177.273030001 | 2096204.98812 | 37.7366878401785 | -122.38652151236201 | (37.7366878401785, -122.386521512362) | ||||
42268 | 42268 | 53726 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/1972 12:00:00 AM | 8 | Permit Number 9405 | 6012451.87174 | 2095251.14558 | 37.733861851932296 | -122.399334980939 | (37.7338618519323, -122.399334980939) | ||
42862 | 42862 | 249675 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Baker St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 49 | 5999731.49147 | 2117154.85585 | 37.7932868206735 | -122.444887014927 | (37.7932868206735, -122.444887014927) | ||||
43247 | 43247 | 206809 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 301 Santa Clara Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5993136.60474 | 2095988.10772 | 37.7347899225997 | -122.46616667426399 | (37.7347899225997, -122.466166674264) | ||||
43852 | 43852 | 205920 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 511 Joost Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 50 | 5998677.95267 | 2094953.56375 | 37.7322674609713 | -122.446933978918 | (37.7322674609713, -122.446933978918) | ||||
44565 | 44565 | 201717 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6017089.1408 | 2095350.86435 | 37.7343930239173 | -122.38330932287201 | (37.7343930239173, -122.383309322872) | ||||
44996 | 44996 | 190978 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1429 Rhode Island St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | 6012034.10728 | 2101710.80673 | 37.7515754115935 | -122.40123309992201 | (37.7515754115935, -122.401233099922) | ||||
45680 | 45680 | 176101 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 491 La Grande Ave | 3 | : Yard 23 | Tree 1 | Private 1 | 26 | 6004411.36222 | 2089192.97967 | 37.716776055035794 | -122.426702192554 | (37.7167760550358, -122.426702192554) | ||||
46071 | 46071 | 223740 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1760 Diamond St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6002036.21609 | 2098593.82428 | 37.742454062002395 | -122.43558404729299 | (37.7424540620024, -122.435584047293) | ||||
46888 | 46888 | 223710 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 67 | 6004258.36813 | 2095937.1689 | 37.735285453551604 | -122.427711264267 | (37.7352854535516, -122.427711264267) | ||||
47893 | 47893 | 223716 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1101 San Jose Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004761.80581 | 2096370.25265 | 37.7365030690611 | -122.42600151366399 | (37.7365030690611, -122.426001513664) | ||||
48845 | 48845 | 206816 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2187x 09th Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5993579.5371900005 | 2100911.34414 | 37.7483334374322 | -122.46499276043001 | (37.7483334374322, -122.46499276043) | ||||
48891 | 48891 | 217772 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 470 West Portal Ave | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 5991503.34429 | 2096106.95053 | 37.735021868547605 | -122.471822023172 | (37.7350218685476, -122.471822023172) | ||||
49019 | 49019 | 217851 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Woodacre Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5991372.3988 | 2095655.7532099998 | 37.7337754172003 | -122.47224186449301 | (37.7337754172003, -122.472241864493) | ||||
49562 | 49562 | 223703 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 77 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004573.37155 | 2096423.41392 | 37.7366383864359 | -122.426656795699 | (37.7366383864359, -122.426656795699) | ||||
49820 | 49820 | 223735 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1760 Diamond St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 34 | 6002021.50784 | 2098799.04405 | 37.7430167120556 | -122.43564958267 | (37.7430167120556, -122.43564958267) | ||||
50152 | 50152 | 113698 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 80 LINARES AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 5994154.8 | 2102090.7 | 37.75160480205479 | -122.46308908916401 | (37.7516048020548, -122.463089089164) | |||||
51235 | 51235 | 201716 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6017085.9132900005 | 2095352.6498 | 37.7343977480421 | -122.38332060578001 | (37.7343977480421, -122.38332060578) | ||||
51562 | 51562 | 218296 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Woodacre Dr | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | 5991178.95125 | 2095337.5178200002 | 37.732890425845106 | -122.47288746619499 | (37.7328904258451, -122.472887466195) | ||||
52516 | 52516 | 247060 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399 Diamond Heights Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | 6001954.14526 | 2098563.8361299997 | 37.7423670597824 | -122.435865678079 | (37.7423670597824, -122.435865678079) | ||||
53056 | 53056 | 248184 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 216 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 28 | 6007432.5204300005 | 2098714.89498 | 37.7430915158666 | -122.416933765486 | (37.7430915158666, -122.416933765486) | ||||
53440 | 53440 | 126417 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2745 Larkin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6006522.5634 | 2120685.74713 | 37.8033669833519 | -122.42164030356301 | (37.8033669833519, -122.421640303563) | ||||
53546 | 53546 | 223712 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 75 | Front Yard : Yard 7 | Tree 1 | Private 1 | 59 | 6004557.86024 | 2096180.22234 | 37.7359697602838 | -122.426693112116 | (37.7359697602838, -122.426693112116) | ||||
53725 | 53725 | 223707 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6004449.31264 | 2096325.41802 | 37.7363622972844 | -122.42707874320699 | (37.7363622972844, -122.427078743207) | ||||
55220 | 55220 | 247018 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 500 Valley St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | 6002543.34779 | 2099196.44547 | 37.744137510129704 | -122.43387360329399 | (37.7441375101297, -122.433873603294) | ||||
55847 | 55847 | 201720 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6017109.38533 | 2095355.2358400002 | 37.734406145933704 | -122.383239634411 | (37.7344061459337, -122.383239634411) | ||||
57404 | 57404 | 190967 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 43 | 6011275.2709 | 2104408.12846 | 37.7589392970181 | -122.404047070529 | (37.7589392970181, -122.404047070529) | ||||
58052 | 58052 | 223695 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1001 San Jose Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6005104.91543 | 2096758.07935 | 37.73758733938811 | -122.42484281995701 | (37.7375873393881, -122.424842819957) | ||||
58146 | 58146 | 201718 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6017093.28201 | 2095356.3247099998 | 37.7344082458391 | -122.38329538517401 | (37.7344082458391, -122.383295385174) | ||||
58189 | 58189 | 190989 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 301x Cashmere St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6016178.9228300005 | 2096206.88071 | 37.7366931281786 | -122.386515940161 | (37.7366931281786, -122.386515940161) | ||||
58790 | 58790 | 205909 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 14 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 56 | 6000896.43949 | 2095509.3176099998 | 37.733919926568106 | -122.43930400388399 | (37.7339199265681, -122.439304003884) | ||||
59780 | 59780 | 126415 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2836 Larkin St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 48 | 6006502.51226 | 2121001.4648 | 37.804232732814704 | -122.421732129727 | (37.8042327328147, -122.421732129727) | ||||
60460 | 60460 | 217838 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Cranleigh Dr | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 5991394.82586 | 2095823.8530599999 | 37.7342382748577 | -122.47217657729799 | (37.7342382748577, -122.472176577298) | ||||
60954 | 60954 | 206815 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2187x 09th Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 5993562.9787 | 2100880.73772 | 37.7482484452101 | -122.465047796213 | (37.7482484452101, -122.465047796213) | ||||
61253 | 61253 | 218150 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 Ashton Ave | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 5994126.47455 | 2090031.2465099997 | 37.7184908913149 | -122.46231247944999 | (37.7184908913149, -122.46231247945) | ||||
61866 | 61866 | 217776 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 470 West Portal Ave | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5991452.16758 | 2096080.8215400001 | 37.7349471636769 | -122.47199705373501 | (37.7349471636769, -122.471997053735) | ||||
61997 | 61997 | 217777 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 470 West Portal Ave | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | 5991442.94255 | 2096087.95113 | 37.734966205907604 | -122.472029467093 | (37.7349662059076, -122.472029467093) | ||||
62551 | 62551 | 223750 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5200x Diamond Heights Blvd | 48 | Median : Yard 3 | Tree 1 | DPW 2 | 49 | 6001781.7092699995 | 2098716.14984 | 37.7427754806136 | -122.436472807673 | (37.7427754806136, -122.436472807673) | ||||
63009 | 63009 | 217778 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 470 West Portal Ave | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 45 | 5991434.0995 | 2096075.0673099998 | 37.734930318469296 | -122.472059101568 | (37.7349303184693, -122.472059101568) | ||||
63370 | 63370 | 205913 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 198 Mangels Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | 6000143.15756 | 2095258.9913 | 37.733189693253706 | -122.44189036057301 | (37.7331896932537, -122.441890360573) | ||||
63473 | 63473 | 205910 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 192 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | 6000206.522969999 | 2095259.2471900003 | 37.7331940064051 | -122.44167130819599 | (37.7331940064051, -122.441671308196) | ||||
63703 | 63703 | 126423 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401 The Embarcadero | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 47 | 6010525.17738 | 2122242.65614 | 37.8078667556044 | -122.40789889741899 | (37.8078667556044, -122.407898897419) | ||||
64573 | 64573 | 206839 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 112 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 41 | 5998729.31623 | 2093223.3736599998 | 37.7275196997604 | -122.446631964111 | (37.7275196997604, -122.446631964111) | ||||
64791 | 64791 | 247022 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 550x Valley St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | 6002376.503830001 | 2099165.28078 | 37.744042469788 | -122.434448284462 | (37.744042469788, -122.434448284462) | ||||
65345 | 65345 | 190991 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 301x Cashmere St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016140.771930001 | 2096185.18124 | 37.7366314337791 | -122.38664633287901 | (37.7366314337791, -122.386646332879) | ||||
65706 | 65706 | 201723 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6017160.60225 | 2095378.34378 | 37.734472425960895 | -122.383064166774 | (37.7344724259609, -122.383064166774) | ||||
65775 | 65775 | 176097 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 184 Mount Vernon Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998962.663240001 | 2089377.08137 | 37.716971995749795 | -122.445548820645 | (37.7169719957498, -122.445548820645) | ||||
65855 | 65855 | 217846 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Woodacre Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 54 | 5991427.317980001 | 2095733.50913 | 37.733992093541396 | -122.47205765993601 | (37.7339920935414, -122.472057659936) | ||||
67292 | 67292 | 217766 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 470 West Portal Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 5991542.55678 | 2096128.2471099999 | 37.7350826123727 | -122.47168800442101 | (37.7350826123727, -122.471688004421) | ||||
67634 | 67634 | 206814 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2187x 09th Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5993540.83818 | 2100833.0540400003 | 37.748116241270104 | -122.465120894018 | (37.7481162412701, -122.465120894018) | ||||
69463 | 69463 | 205919 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 230 Edna St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | 5998797.1475 | 2095343.94395 | 37.7333461617934 | -122.44654997291599 | (37.7333461617934, -122.446549972916) | ||||
70384 | 70384 | 126420 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 957 Green St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6008389.07771 | 2118963.83905 | 37.798744126289 | -122.415059188055 | (37.798744126289, -122.415059188055) | ||||
71003 | 71003 | 223708 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 220 Coso Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6007533.84485 | 2099558.41005 | 37.7454133189685 | -122.416643154074 | (37.7454133189685, -122.416643154074) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");