trees
451 rows where qLegalStatus_id = 4 and qSpecies_id = 53
This data as json, CSV (advanced)
These facets timed out: Supervisor Districts, qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
117 | 108152 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2232 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
261 | 119280 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 95 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995293 | 2090512 | 37.7198780283713 | -122.458315087488 | (37.7198780283713, -122.458315087488) | 9 | 8 | 6 | 28861 | 24 | ||||
770 | 111807 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50X COLUMBIA SQUARE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
2280 | 116028 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1500 PACIFIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006937 | 2117734 | 37.7952855901943 | -122.419996533467 | (37.7952855901943, -122.419996533467) | 13 | 9 | 10 | 28858 | 32 | ||||
2653 | 100053 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | |||
3804 | 117402 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
4294 | 117126 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 766 NOE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6003023 | 2103770 | 37.7567226205836 | -122.432541687014 | (37.7567226205836, -122.432541687014) | 2 | 4 | 5 | 28862 | 3 | |||
4983 | 112267 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
5722 | 255886 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50 Columbia Square St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
6188 | 111792 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
7359 | 121255 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 283 Dorland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003780 | 2105549 | 37.7616502297697 | -122.430050607682 | (37.7616502297697, -122.430050607682) | 8 | 4 | 5 | 28862 | 3 | ||||
8209 | 103628 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1450X Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.7687644406503 | -122.421417350008 | (37.7687644406503, -122.421417350008) | 8 | 4 | 7 | 28853 | 19 | ||
8269 | 99967 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2270 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
8384 | 104821 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2173 15TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003063.7 | 2107068.1 | 37.7657807169148 | -122.432636512343 | (37.7657807169148, -122.432636512343) | 15 | 5 | 5 | 28862 | 3 | |||||
8496 | 115992 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 438 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2016 12:00:00 AM | 3 | Permit Number 778644 | 5989723.9 | 2112354.3 | 37.7795296278249 | -122.479162248453 | (37.7795296278249, -122.479162248453) | 11 | 6 | 2 | 55 | 26 | ||
8565 | 105233 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1508 WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5998474.1 | 2108297 | 37.7688936152058 | -122.448599407064 | (37.7688936152058, -122.448599407064) | 15 | 5 | 11 | 29492 | 9 | |||
8959 | 113224 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 4244 23RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001623 | 2102374 | 37.7528100494278 | -122.437283434624 | (37.7528100494278, -122.437283434624) | 2 | 4 | 5 | 28862 | 22 | ||||
9438 | 115058 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 499X BRANNAN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013762 | 2111312 | 37.7780344196247 | -122.395930522096 | (37.7780344196247, -122.395930522096) | 6 | 2 | 9 | 28856 | 34 | ||||
10358 | 120965 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1145x Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003243 | 2101623 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | 2 | 4 | 5 | 28862 | 22 | ||||
10859 | 102456 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
11207 | 108105 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2390X Green St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 | |||||
11284 | 117186 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 201x GREENWICH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011833 | 2120374 | 37.8028090150843 | -122.40324129087 | (37.8028090150843, -122.40324129087) | 3 | 1 | 10 | 308 | 23 | ||||
11335 | 112269 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
11498 | 115743 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X POND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Rec/Park | 28 | 3x3 | 6003250 | 2106477 | 37.764168263012 | -122.431949928803 | (37.764168263012, -122.431949928803) | 15 | 4 | 5 | 28862 | 3 | ||
12765 | 117400 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
13581 | 113413 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 16X LEROY PL | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 1x1 | 6008359 | 2116497 | 37.7919691052865 | -122.414988572568 | (37.7919691052865, -122.414988572568) | 5 | 1 | 10 | 28858 | 21 | |||
14328 | 104230 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 409 Walnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14x8 | 5998587.6 | 2115205.6 | 37.787869332154 | -122.448704479556 | (37.787869332154, -122.448704479556) | 13 | 6 | 1 | 54 | 31 | ||||
14899 | 110708 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2999X Turk St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
17055 | 104825 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45 Prosper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003350 | 2106266 | 37.7635945765505 | -122.431588992909 | (37.7635945765505, -122.431588992909) | 15 | 4 | 5 | 28862 | 3 | |||
18243 | 96948 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 900X Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 6x6 | 6007359.7 | 2102053.2 | 37.7522536530624 | -122.417422091759 | (37.7522536530624, -122.417422091759) | 2 | 4 | 7 | 28859 | 19 | |||
18422 | 112268 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
18675 | 101715 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
18772 | 115057 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 499X BRANNAN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013762 | 2111312 | 37.7780344196247 | -122.395930522096 | (37.7780344196247, -122.395930522096) | 6 | 2 | 9 | 28856 | 34 | ||||
19076 | 99594 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1855X Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6014349.8 | 2099426.2 | 37.7454312840379 | -122.393065244865 | (37.7454312840379, -122.393065244865) | 10 | 3 | 8 | 58 | 1 | |||
19705 | 95415 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 49X South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Created record for this tree on 2/28/2011 although tree is approxmiately 20 years old. | 6007102.30356 | 2110018.85993 | 37.7741110108752 | -122.418877107651 | (37.7741110108752, -122.418877107651) | 8 | 2 | 9 | 28853 | 19 | ||
20034 | 255882 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50 Columbia Square St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
20084 | 115908 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||
20131 | 113298 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700X DAVIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013208 | 2119104 | 37.7993985951424 | -122.398393892143 | (37.7993985951424, -122.398393892143) | 3 | 1 | 10 | 28860 | 6 | ||||
20147 | 103506 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1348 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
20310 | 112288 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 895x PAGE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002361 | 2109458 | 37.7723029182135 | -122.435237957834 | (37.7723029182135, -122.435237957834) | 15 | 5 | 11 | 29492 | 9 | ||||
20709 | 109328 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1349 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2015 12:00:00 AM | 3 | 3x3 | 5999000.5 | 2104870.1 | 37.7595142924854 | -122.446532051538 | (37.7595142924854, -122.446532051538) | 15 | 5 | 5 | 28862 | 12 | ||
20820 | 111597 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 398X BRYANT ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014483 | 2113360 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | 6 | 2 | 9 | 28856 | 6 | ||||
21498 | 98979 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 38 MILEY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 778225 | 5999656 | 2118689 | 37.7974948649915 | -122.4452585722 | (37.7974948649915, -122.4452585722) | 13 | 9 | 1 | 57 | 17 | ||
21841 | 111225 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
24151 | 96336 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1851 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005204.9 | 2107156.8 | 37.7661454629436 | -122.42523686393 | (37.7661454629436, -122.42523686393) | 8 | 4 | 5 | 28853 | 19 | |||
24579 | 96732 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 514 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3.5 | 6007319.4 | 2106562.9 | 37.7646339820142 | -122.417881101898 | (37.7646339820142, -122.417881101898) | 8 | 4 | 7 | 28859 | 19 | |||
25734 | 113701 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 12 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6007151 | 2099622 | 37.7455663833026 | -122.417971480149 | (37.7455663833026, -122.417971480149) | 2 | 7 | 7 | 28859 | 2 | |||
26375 | 111795 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
26933 | 120656 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 160 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
27040 | 120661 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 299X Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
27436 | 107660 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1316 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5999083.9 | 2105040.7 | 37.7599874810533 | -122.446255886285 | (37.7599874810533, -122.446255886285) | 15 | 5 | 5 | 28862 | 3 | |||
27991 | 97561 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1251X 04th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5994791.4 | 2106981 | 37.7650689602603 | -122.461242116604 | (37.7650689602603, -122.461242116604) | 15 | 5 | 11 | 56 | 12 | ||||
28234 | 109001 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
28305 | 121625 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 101x Trenton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010049 | 2117862 | 37.7958118850813 | -122.409237502382 | (37.7958118850813, -122.409237502382) | 3 | 1 | 10 | 308 | 4 | ||||
28626 | 100399 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 900 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 4x4 | 6011664 | 2118384 | 37.7973355180624 | -122.403686018548 | (37.7973355180624, -122.403686018548) | 3 | 1 | 10 | 308 | 23 | ||
28662 | 99265 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1340 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008042 | 2117018 | 37.7933818247157 | -122.416122311937 | (37.7933818247157, -122.416122311937) | 5 | 1 | 10 | 28858 | 21 | |||||
28710 | 102826 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2001X Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997438 | 2109144 | 37.7711599615563 | -122.452244312179 | (37.7711599615563, -122.452244312179) | 15 | 5 | 11 | 29492 | 9 | ||||
29615 | 120137 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
31383 | 110696 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2999X Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
32372 | 111797 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 14 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
32399 | 102602 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 Spear St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | 12 | 2 | 9 | 28855 | 6 | |||
33102 | 110710 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2999X Turk St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
35016 | 120999 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 390 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6010815 | 2115725 | 37.7899870820688 | -122.406436332672 | (37.7899870820688, -122.406436332672) | 5 | 1 | 10 | 28857 | 6 | ||||
35050 | 115907 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||
35179 | 95222 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 299 on 16th St Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004880 | 2106610 | 37.7646257206218 | -122.426321695151 | (37.7646257206218, -122.426321695151) | 8 | 4 | 5 | 28859 | 19 | |||
35372 | 94058 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1401X 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5993648 | 2105942 | 37.7621502689837 | -122.465121353228 | (37.7621502689837, -122.465121353228) | 1 | 8 | 11 | 56 | 12 | |||
35952 | 120884 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2140x 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011295 | 2105636 | 37.7623118602886 | -122.404065249735 | (37.7623118602886, -122.404065249735) | 8 | 3 | 8 | 28856 | 29 | ||||
36005 | 111369 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 724 IRVING ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993485 | 2106687 | 37.7641864431876 | -122.465739233402 | (37.7641864431876, -122.465739233402) | 11 | 8 | 11 | 56 | 12 | ||||
36076 | 111627 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11X SOUTH VAN NESS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007074 | 2110234 | 37.7747001403616 | -122.418990277193 | (37.7747001403616, -122.418990277193) | 8 | 2 | 9 | 28853 | 19 | ||||
37186 | 112411 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 300x 15TH ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011264 | 2107649 | 37.7678373720049 | -122.404314158491 | (37.7678373720049, -122.404314158491) | 8 | 2 | 8 | 28853 | 20 | ||||
37914 | 110712 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2999X Turk St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
38468 | 111626 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11X SOUTH VAN NESS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007074 | 2110234 | 37.7747001403616 | -122.418990277193 | (37.7747001403616, -122.418990277193) | 8 | 2 | 9 | 28853 | 19 | ||||
38651 | 113775 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1712 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6000121 | 2114885 | 37.7870766118482 | -122.443376178084 | (37.7870766118482, -122.443376178084) | 13 | 6 | 1 | 29490 | 27 | |||
38715 | 120144 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 | ||||
38742 | 113004 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
38782 | 101759 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.417906860029 | (37.7750397101602, -122.417906860029) | 8 | 2 | 9 | 28853 | 34 | |||
38859 | 115059 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 499X BRANNAN ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013762 | 2111312 | 37.7780344196247 | -122.395930522096 | (37.7780344196247, -122.395930522096) | 6 | 2 | 9 | 28856 | 34 | ||||
38950 | 93145 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1152 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991985 | 2113459 | 37.7826938870859 | -122.471420727494 | (37.7826938870859, -122.471420727494) | 11 | 6 | 2 | 54 | 11 | |||||
39370 | 107630 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2164 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6001495 | 2119755 | 37.8005266206576 | -122.438971595662 | (37.8005266206576, -122.438971595662) | 13 | 9 | 1 | 57 | 17 | |||
41004 | 99266 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1340 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008042 | 2117018 | 37.7933818247157 | -122.416122311937 | (37.7933818247157, -122.416122311937) | 5 | 1 | 10 | 28858 | 21 | ||||
41221 | 96947 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 900X Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 6x6 | 6007389 | 2101516 | 37.750780272338 | -122.417282702809 | (37.750780272338, -122.417282702809) | 2 | 4 | 7 | 28859 | 19 | |||
41773 | 120139 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
43227 | 110731 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3515 25TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006381 | 2101411 | 37.7504352040325 | -122.420761009138 | (37.7504352040325, -122.420761009138) | 2 | 4 | 5 | 28859 | 19 | ||||
43330 | 113005 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
43367 | 116602 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3260x 16TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 9x9 | 6005124 | 2106632 | 37.764699916645 | -122.425479329399 | (37.764699916645, -122.425479329399) | 8 | 4 | 5 | 28859 | 19 | |||
43430 | 112751 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 135X TRENTON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6009947 | 2118097 | 37.7964514227226 | -122.409607037418 | (37.7964514227226, -122.409607037418) | 3 | 1 | 10 | 308 | 4 | |||
43513 | 120964 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1145x Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003243 | 2101623 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | 2 | 4 | 5 | 28862 | 22 | ||||
43596 | 112404 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 300x 15TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011264 | 2107649 | 37.7678373720049 | -122.404314158491 | (37.7678373720049, -122.404314158491) | 8 | 2 | 8 | 28853 | 20 | ||||
43639 | 111595 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 398X BRYANT ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014483 | 2113360 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | 6 | 2 | 9 | 28856 | 6 | ||||
43985 | 111817 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 80 ORD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6000817 | 2105938 | 37.7625500726099 | -122.440326296311 | (37.7625500726099, -122.440326296311) | 15 | 5 | 5 | 28862 | 3 | |||
44100 | 115215 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3395x 21ST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2016 12:00:00 AM | 3 | 9x5 | Permit Number 779049 | 6005778 | 2103691 | 37.7566615513452 | -122.423008263345 | (37.7566615513452, -122.423008263345) | 2 | 4 | 5 | 28859 | 19 | |
44451 | 96734 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 520 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3.5 | 6007401.6 | 2106571.6 | 37.7646624959011 | -122.417597409955 | (37.7646624959011, -122.417597409955) | 8 | 4 | 7 | 28859 | 19 | |||
46032 | 121039 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2101 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118098 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | 13 | 9 | 10 | 28858 | 32 | ||||
46738 | 113373 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 HOWARD ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2015 12:00:00 AM | 3x3 | 6014757 | 2116474 | 37.7922633974731 | -122.39284966575 | (37.7922633974731, -122.39284966575) | 12 | 2 | 9 | 28855 | 6 | |||
46917 | 122714 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 855x Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011188 | 2117923 | 37.7960431220576 | -122.40530062832 | (37.7960431220576, -122.40530062832) | 3 | 1 | 10 | 28857 | 4 | ||||
47028 | 110967 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2439 WASHINGTON ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003043 | 2116458 | 37.7915618650441 | -122.433379161821 | (37.7915618650441, -122.433379161821) | 13 | 9 | 1 | 29490 | 27 | ||||
47816 | 107839 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1000x LEAVENWORTH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008256 | 2115925 | 37.790392745036 | -122.415304443955 | (37.790392745036, -122.415304443955) | 5 | 1 | 10 | 28858 | 21 | ||||
47908 | 101764 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.417906860029 | (37.7750397101602, -122.417906860029) | 8 | 2 | 9 | 28853 | 34 | |||
48110 | 108103 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2390X Green St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 | |||||
48222 | 100107 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 461 Jefferson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007004.8 | 2122229.7 | 37.8076334645768 | -122.420081138169 | (37.8076334645768, -122.420081138169) | 5 | 1 | 1 | 308 | 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) );