trees
963 rows where qCaretaker_id = 2 and qSpecies_id = 53 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34974 | 253521 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2626 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 6006643 | 2120264 | 37.8022157634914 | -122.42119356192 | (37.8022157634914, -122.42119356192) | 5 | 1 | 1 | 28858 | 32 | ||
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 | |||
35514 | 110994 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
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 | ||||
37194 | 4729 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1075 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6008196.257 | 2120907.29394 | 37.8040695291651 | -122.41586410452 | (37.8040695291651, -122.41586410452) | 5 | 1 | 10 | 308 | 32 | |||
37406 | 18007 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2700X Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x4 | 6001006.5406952 | 2114902.0443839 | 37.7871738702805 | -122.440313633737 | (37.7871738702805, -122.440313633737) | 13 | 6 | 1 | 29490 | 27 | |||
37838 | 102503 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 290X Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x9 | 6003881.1 | 2108703.5 | 37.7703174504719 | -122.429925966233 | (37.7703174504719, -122.429925966233) | 7 | 9 | 11 | 29492 | 10 | ||||
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 | |||
38667 | 21584 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1499 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005574.52113 | 2114792.70084 | 37.787132663766 | -122.424501615425 | (37.787132663766, -122.424501615425) | 13 | 9 | 1 | 28858 | 41 | |||
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 | |||||
39288 | 116011 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1448 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2016 12:00:00 AM | 3 | 6000920 | 2110390.8 | 37.7747822166773 | -122.440289401956 | (37.7747822166773, -122.440289401956) | 15 | 5 | 11 | 29492 | 10 | |||
39348 | 97611 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 349 10th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009106.7 | 2109348.6 | 37.7723832922197 | -122.411896150488 | (37.7723832922197, -122.411896150488) | 8 | 2 | 9 | 28853 | 34 | ||||
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 | |||
39669 | 95554 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1333@ Larkin Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007121 | 2115358 | 37.7887720478953 | -122.419191239667 | (37.7887720478953, -122.419191239667) | 13 | 9 | 10 | 28858 | 21 | |||||
40868 | 173774 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2239 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002625 | 2107043 | 37.7656869095489 | -122.434152085943 | (37.7656869095489, -122.434152085943) | 15 | 5 | 5 | 28862 | 3 | ||||
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 | |||
41634 | 13254 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2408 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 45 | 3X3 | 6000832.23006 | 2119380.36917 | 37.7994602521243 | -122.441238147567 | (37.7994602521243, -122.441238147567) | 13 | 9 | 1 | 57 | 17 | ||
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 | ||||
41963 | 21634 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1629 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6004806.293908 | 2114684.9896753 | 37.786793502462 | -122.427151839633 | (37.786793502462, -122.427151839633) | 13 | 9 | 11 | 28858 | 13 | |||
42506 | 121635 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 506 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2017 12:00:00 AM | 3 | 3x3 | 5992560 | 2111978 | 37.7786607112968 | -122.469323657797 | (37.7786607112968, -122.469323657797) | 11 | 6 | 2 | 54 | 11 | ||
43224 | 117205 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013468.70293325 | 2105662.80878203 | 37.762506682391 | -122.396549051509 | (37.762506682391, -122.396549051509) | 10 | 3 | 8 | 28856 | 29 | |||||
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 | |||
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 | ||||
43818 | 24454 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1384 Valencia St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.7508023001764 | -122.420834214589 | (37.7508023001764, -122.420834214589) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
44244 | 110995 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
44254 | 20167 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1175 Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 4X4 | 6002828.6579039 | 2112263.6806979 | 37.7800331654734 | -122.433820860908 | (37.7800331654734, -122.433820860908) | 15 | 9 | 11 | 29490 | 41 | |||
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 | |||||
48272 | 95217 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 135 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6005910 | 2106464 | 37.7642830068396 | -122.422748818687 | (37.7642830068396, -122.422748818687) | 8 | 4 | 5 | 28859 | 19 | |||
48350 | 111430 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500X PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999200 | 2114887 | 37.7870295394193 | -122.446562765799 | (37.7870295394193, -122.446562765799) | 15 | 6 | 1 | 29490 | 31 | ||||
48462 | 111114 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2085 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5997903.58032533 | 2109906.22418863 | 37.7732794935428 | -122.450688824407 | (37.7732794935428, -122.450688824407) | 15 | 5 | 11 | 29492 | 16 | ||||
48551 | 18500 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 519X Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4X4 | 6010154.14929 | 2115557.66128 | 37.7894906186413 | -122.408711019419 | (37.7894906186413, -122.408711019419) | 5 | 1 | 10 | 28857 | 21 | |||
48959 | 112162 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1324 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013680.97327942 | 2105726.70860795 | 37.7626939483281 | -122.39581935837 | (37.7626939483281, -122.39581935837) | 14 | 3 | 8 | 28856 | 29 | ||||
48975 | 21630 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1615 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/1990 12:00:00 AM | 6 | 4X4 | 6004701.1521 | 2114671.0024 | 37.786749150585 | -122.427514608894 | (37.786749150585, -122.427514608894) | 13 | 9 | 11 | 28858 | 13 | ||
49389 | 11091 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1906 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3X3 | 6007294.23278 | 2118880.01642 | 37.7984523847496 | -122.418841764779 | (37.7984523847496, -122.418841764779) | 5 | 1 | 10 | 28858 | 32 | |||
49412 | 94931 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1771 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004522 | 2118744 | 37.7979224352085 | -122.428424847305 | (37.7979224352085, -122.428424847305) | 13 | 9 | 1 | 57 | 17 | |||||
49558 | 113001 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
50036 | 100262 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 40 Federal St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6014922 | 2113400.9 | 37.7838345339316 | -122.392063753471 | (37.7838345339316, -122.392063753471) | 6 | 2 | 9 | 28856 | 6 | |||
50788 | 113510 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 320 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008411 | 2113171 | 37.7828396386737 | -122.414573186563 | (37.7828396386737, -122.414573186563) | 7 | 10 | 9 | 28852 | 36 | ||||
50810 | 20244 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1801X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002529.5506914 | 2114404.1561918 | 37.7858933925245 | -122.435008734319 | (37.7858933925245, -122.435008734319) | 13 | 9 | 1 | 29490 | 27 | |||
50875 | 7183 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 857 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003432.47617 | 2111314.05853 | 37.7774599847744 | -122.43166416476 | (37.7774599847744, -122.43166416476) | 15 | 9 | 11 | 29492 | 10 | |||
51092 | 109603 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 602 SHOTWELL ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007851.6 | 2104381.9 | 37.758675396701 | -122.415885905109 | (37.758675396701, -122.415885905109) | 2 | 4 | 7 | 28859 | 19 | ||||
51694 | 173776 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 89 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001439 | 2105287 | 37.7607979807122 | -122.438128392537 | (37.7607979807122, -122.438128392537) | 15 | 4 | 5 | 28862 | 3 | ||||
51742 | 11446 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2191X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005072.64937 | 2117089.85961 | 37.7934117301419 | -122.426401604865 | (37.7934117301419, -122.426401604865) | 13 | 9 | 1 | 28858 | 27 | |||
52074 | 117185 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 201x GREENWICH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011833 | 2120374 | 37.8028090150843 | -122.40324129087 | (37.8028090150843, -122.40324129087) | 3 | 1 | 10 | 308 | 23 | ||||
52375 | 120531 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1390 Waller St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999052.33988667 | 2108383.59508746 | 37.7691644298026 | -122.446605553634 | (37.7691644298026, -122.446605553634) | 15 | 5 | 11 | 29492 | 9 | ||||
52775 | 18497 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 501 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6010150.58942 | 2115513.37022 | 37.7893688066449 | -122.408720210327 | (37.7893688066449, -122.408720210327) | 5 | 1 | 10 | 28857 | 21 | |||
53203 | 110987 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
53498 | 24453 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1384 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.7508023001764 | -122.420834214589 | (37.7508023001764, -122.420834214589) | 2 | 4 | 5 | 28859 | 19 | |||
53748 | 110363 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1899x MARIPOSA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011823 | 2106021 | 37.7633984709679 | -122.402266155018 | (37.7633984709679, -122.402266155018) | 8 | 3 | 8 | 28856 | 29 | ||||
53774 | 20090 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2075X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 5997085.68869 | 2109091.58753 | 37.7709958615587 | -122.453459178714 | (37.7709958615587, -122.453459178714) | 15 | 5 | 11 | 29492 | 9 | |||
54160 | 110730 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3515 25TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006381 | 2101411 | 37.7504352040325 | -122.420761009138 | (37.7504352040325, -122.420761009138) | 2 | 4 | 5 | 28859 | 19 | ||||
54470 | 101758 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 1 | 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 | |||
54784 | 101716 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
55250 | 112408 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 300x 15TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011264 | 2107649 | 37.7678373720049 | -122.404314158491 | (37.7678373720049, -122.404314158491) | 8 | 2 | 8 | 28853 | 20 | ||||
55811 | 115056 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 499X BRANNAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013762 | 2111312 | 37.7780344196247 | -122.395930522096 | (37.7780344196247, -122.395930522096) | 6 | 2 | 9 | 28856 | 34 | ||||
56045 | 108604 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 625 LEAVENWORTH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6008310.7 | 2114660.6 | 37.7869240847944 | -122.415025652231 | (37.7869240847944, -122.415025652231) | 13 | 1 | 9 | 28858 | 36 | |||
56222 | 121122 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | ||||
56413 | 111223 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
56447 | 117399 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
56472 | 96337 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1851 15th St | 2 | 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 | |||
57261 | 111200 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 801x CAYUGA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001252 | 2092235 | 37.7249496290087 | -122.437840285791 | (37.7249496290087, -122.437840285791) | 9 | 7 | 6 | 28861 | 25 | ||||
57390 | 9617 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1050X Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6002921.99888 | 2111973.13636 | 37.7792406996886 | -122.433477183837 | (37.7792406996886, -122.433477183837) | 15 | 9 | 11 | 29490 | 41 | |||
57627 | 114283 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 200X STEUART ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015060 | 2116254 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | 6 | 2 | 9 | 28855 | 6 | ||||
57727 | 4728 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1075 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6008196.257 | 2120907.29394 | 37.8040695291651 | -122.41586410452 | (37.8040695291651, -122.41586410452) | 5 | 1 | 10 | 308 | 32 | |||
57818 | 111388 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 298x CLINTON PARK | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004911 | 2108307 | 37.7692870280045 | -122.426335307428 | (37.7692870280045, -122.426335307428) | 8 | 4 | 5 | 28862 | 19 | |||
57879 | 101766 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 9 | 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 | |||
57914 | 106105 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 744x MONTGOMERY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011751.6 | 2117873.5 | 37.7959387009634 | -122.403346966666 | (37.7959387009634, -122.403346966666) | 3 | 1 | 10 | 28860 | 4 | |||||
58111 | 258045 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | 3x3 | 6007719 | 2121534 | 37.805763462997 | -122.417560134413 | (37.805763462997, -122.417560134413) | 5 | 1 | 10 | 308 | 23 | ||
58136 | 106999 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 10 Loyola Ter | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998469.2817 | 2110801.2236 | 37.7757692966762 | -122.448796472896 | (37.7757692966762, -122.448796472896) | 15 | 6 | 2 | 29492 | 16 | |||||
58653 | 24451 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1384 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.7508023001764 | -122.420834214589 | (37.7508023001764, -122.420834214589) | 2 | 4 | 5 | 28859 | 19 | |||
58860 | 111391 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 298x CLINTON PARK | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004911 | 2108307 | 37.7692870280045 | -122.426335307428 | (37.7692870280045, -122.426335307428) | 8 | 4 | 5 | 28862 | 19 | ||||
59389 | 102825 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2001X Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997438 | 2109144 | 37.7711599615563 | -122.452244312179 | (37.7711599615563, -122.452244312179) | 15 | 5 | 11 | 29492 | 9 | ||||
59516 | 120135 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
59611 | 106127 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1609 POWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6009609.6 | 2119208.8 | 37.7994852403002 | -122.410853080764 | (37.7994852403002, -122.410853080764) | 3 | 1 | 10 | 308 | 4 |
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) );