trees
408 rows where Police Districts = 9 and qSpecies_id = 53 sorted by PlotSize descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 59694 | 127215 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 4 | Front Yard : Yard | Tree | Private 2 | 8 | Width 4ft | Permit Number 782825 | 5999937.99418 | 2117121.61309 | 37.7932073277938 | -122.44417011406 | (37.7932073277938, -122.44417011406) | 13 | 9 | 1 | 57 | 27 | ||
| 76207 | 127218 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 7 | Front Yard : Yard | Tree | Private 2 | 8 | Width 4ft | Permit Number 782825 | 5999923.49955 | 2117118.25276 | 37.7931972742965 | -122.44422002466 | (37.7931972742965, -122.44422002466) | 13 | 9 | 1 | 57 | 27 | ||
| 109441 | 127217 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 6 | Front Yard : Yard | Tree | Private 2 | 7 | Width 4ft | Permit Number 782825 | 5999928.92975 | 2117120.95639 | 37.7932050075467 | -122.444201430254 | (37.7932050075467, -122.444201430254) | 13 | 9 | 1 | 57 | 27 | ||
| 147341 | 127216 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 5 | Front Yard : Yard | Tree | Private 2 | 8 | Width 4ft | Permit Number 782825 | 5999932.8876 | 2117120.87416 | 37.7932050075595 | -122.444187729973 | (37.7932050075595, -122.444187729973) | 13 | 9 | 1 | 57 | 27 | ||
| 184158 | 127219 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 8 | Front Yard : Yard | Tree | Private 2 | 8 | Width 4ft | Permit Number 782825 | 5999916.98549 | 2117117.82475 | 37.7931957274607 | -122.444242532876 | (37.7931957274607, -122.444242532876) | 13 | 9 | 1 | 57 | 27 | ||
| 2723 | 140583 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 949 FILLMORE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6003424.6737 | 2111485.9504 | 37.7779315149131 | -122.431703431668 | (37.7779315149131, -122.431703431668) | 15 | 9 | 11 | 29492 | 41 | |||
| 2956 | 139431 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 539 OCTAVIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005398.6042 | 2111220.8061 | 37.7773151849796 | -122.424856035409 | (37.7773151849796, -122.424856035409) | 7 | 9 | 11 | 28852 | 10 | |||
| 5715 | 140049 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 651 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005353.1353 | 2111583.6293 | 37.778308840554 | -122.42503914867 | (37.778308840554, -122.42503914867) | 7 | 9 | 11 | 28852 | 10 | |||
| 6753 | 140065 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 612 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005425.1416 | 2111379.12 | 37.7777513751906 | -122.424775499228 | (37.7777513751906, -122.424775499228) | 7 | 9 | 11 | 28852 | 10 | |||
| 12493 | 140066 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 614 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005423.0428 | 2111393.287 | 37.7777901557735 | -122.424783767818 | (37.7777901557735, -122.424783767818) | 7 | 9 | 11 | 28852 | 10 | |||
| 15896 | 140067 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 616 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005420.4192 | 2111411.6517 | 37.7778404325738 | -122.424794150591 | (37.7778404325738, -122.424794150591) | 7 | 9 | 11 | 28852 | 10 | |||
| 18271 | 139433 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 539 OCTAVIA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005406.0306 | 2111183.3028 | 37.7772126295238 | -122.424827676313 | (37.7772126295238, -122.424827676313) | 7 | 9 | 11 | 28852 | 10 | |||
| 18607 | 139432 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 539 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005403.0601 | 2111196.299 | 37.77724814614 | -122.424838877048 | (37.77724814614, -122.424838877048) | 7 | 9 | 11 | 28852 | 10 | |||
| 71007 | 116518 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 480 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2016 12:00:00 AM | 3 | 9x6 | 6003703 | 2109976 | 37.7738013362642 | -122.430632829648 | (37.7738013362642, -122.430632829648) | 7 | 9 | 11 | 29492 | 10 | ||
| 11231 | 57646 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 666 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1981 12:00:00 AM | 16 | 7x7 | Permit Number 19439 | 6005402.5793 | 2111576.4092 | 37.7782918087921 | -122.424867589608 | (37.7782918087921, -122.424867589608) | 7 | 9 | 11 | 28852 | 10 | |
| 123904 | 98659 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2110 Greenwich St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 20 | 7x7 | 6002683.8 | 2119245.6 | 37.7991955081761 | -122.434821422435 | (37.7991955081761, -122.434821422435) | 13 | 9 | 1 | 57 | 17 | ||
| 142032 | 16862 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 205 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 7x6 | 6005961.9803 | 2110311.49787 | 37.7748502496054 | -122.422842492323 | (37.7748502496054, -122.422842492323) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | ||||
| 61596 | 102505 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 290X Hermann St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x7 | 6003881.1 | 2108703.5 | 37.7703174504719 | -122.429925966233 | (37.7703174504719, -122.429925966233) | 7 | 9 | 11 | 29492 | 10 | ||||
| 21029 | 102504 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 290X Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6003881.1 | 2108703.5 | 37.7703174504719 | -122.429925966233 | (37.7703174504719, -122.429925966233) | 7 | 9 | 11 | 29492 | 10 | ||||
| 99392 | 94300 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6x6 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||
| 101481 | 7279 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1803 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6x6 | 6002990.14459 | 2114551.19489 | 37.7863232654697 | -122.43342571959 | (37.7863232654697, -122.43342571959) | 13 | 9 | 11 | 29490 | 27 | |||
| 81527 | 26942 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x5 | 6002862.4862 | 2114464.90765 | 37.7860790992099 | -122.433861214618 | (37.7860790992099, -122.433861214618) | 13 | 9 | 11 | 29490 | 27 | |||
| 87320 | 9574 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1290X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6x5 | 6003478.20667 | 2112124.62637 | 37.7796881945834 | -122.431563850171 | (37.7796881945834, -122.431563850171) | 15 | 9 | 11 | 29490 | 41 | |||
| 32254 | 26946 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6002793.58315 | 2114456.84816 | 37.7860530596313 | -122.434099024105 | (37.7860530596313, -122.434099024105) | 13 | 9 | 11 | 29490 | 27 | |||
| 35663 | 26954 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6002832.1331203 | 2114461.0177044 | 37.7860666959211 | -122.433965949874 | (37.7860666959211, -122.433965949874) | 13 | 9 | 11 | 29490 | 27 | |||
| 93727 | 26951 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 5x6 | 6002681.79801 | 2114441.89018 | 37.7860056439611 | -122.434484700269 | (37.7860056439611, -122.434484700269) | 13 | 9 | 11 | 29490 | 27 | |||
| 139533 | 26952 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 5x6 | 6002662.57908 | 2114440.54738 | 37.7860008659914 | -122.434551096425 | (37.7860008659914, -122.434551096425) | 13 | 9 | 11 | 29490 | 27 | |||
| 155152 | 26943 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 5x6 | 6002846.96094 | 2114462.84733 | 37.7860725610737 | -122.43391478048 | (37.7860725610737, -122.43391478048) | 13 | 9 | 11 | 29490 | 27 | |||
| 193568 | 26953 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6002643.91242 | 2114436.71459 | 37.7859892824562 | -122.43461540376 | (37.7859892824562, -122.43461540376) | 13 | 9 | 11 | 29490 | 27 | |||
| 43740 | 9577 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1290X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x5 | 6003415.08005 | 2112113.96459 | 37.7796553418115 | -122.431781470984 | (37.7796553418115, -122.431781470984) | 15 | 9 | 11 | 29490 | 41 | |||
| 61417 | 7288 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1860 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x5 | 6003020.21181 | 2114689.03027 | 37.7867034322579 | -122.433331547756 | (37.7867034322579, -122.433331547756) | 13 | 9 | 11 | 29490 | 27 | |||
| 117462 | 12246 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 501 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/2015 03:15:00 PM | 3 | 5x5 | 6004973.20209 | 2110637.42143 | 37.775689316239 | -122.426286094705 | (37.775689316239, -122.426286094705) | 7 | 9 | 11 | 28852 | 10 | ||
| 125597 | 7374 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2498 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x5 | 6002741.92214 | 2116738.58592 | 37.7923151963696 | -122.43444095639 | (37.7923151963696, -122.43444095639) | 13 | 9 | 1 | 29490 | 27 | |||
| 128624 | 117343 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 372 HAYES ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6006019 | 2111114 | 37.7770569433878 | -122.422702290381 | (37.7770569433878, -122.422702290381) | 7 | 9 | 11 | 28852 | 10 | ||||
| 136831 | 7225 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1015 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5x5 | 6003380.095 | 2111793.84702 | 37.7787743954893 | -122.431879635495 | (37.7787743954893, -122.431879635495) | 15 | 9 | 11 | 29490 | 41 | |||
| 142334 | 12245 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 503 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/2015 03:15:00 PM | 3 | 5x5 | Permit Number 780762 | 6004995.5845 | 2110652.4736 | 37.7757319109571 | -122.426209740207 | (37.7757319109571, -122.426209740207) | 7 | 9 | 11 | 28852 | 10 | |
| 181893 | 7246 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1700 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x5 | 6003087.664 | 2114207.65389 | 37.7853855210138 | -122.433063773672 | (37.7853855210138, -122.433063773672) | 13 | 9 | 11 | 29490 | 13 | |||
| 69091 | 7190 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 896 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 5X5 | 6003496.10413 | 2111301.12929 | 37.7774280906657 | -122.431443131507 | (37.7774280906657, -122.431443131507) | 7 | 9 | 11 | 29492 | 10 | |||
| 83917 | 7189 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 896 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5X5 | 6003518.08132 | 2111313.80886 | 37.7774641511736 | -122.43136801056 | (37.7774641511736, -122.43136801056) | 7 | 9 | 11 | 29492 | 10 | |||
| 115819 | 7191 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 896 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 5X5 | 6003494.59692 | 2111314.73243 | 37.7774653560924 | -122.431449316775 | (37.7774653560924, -122.431449316775) | 7 | 9 | 11 | 29492 | 10 | |||
| 29407 | 16958 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 705 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x5 | 6003566.56897 | 2110004.67754 | 37.7738723476787 | -122.431106813505 | (37.7738723476787, -122.431106813505) | 15 | 9 | 11 | 29492 | 10 | |||
| 30808 | 21696 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1890 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/1990 12:00:00 AM | 16 | 4x4 | 6003576.7245218 | 2114564.5327129 | 37.7863931493079 | -122.431397256992 | (37.7863931493079, -122.431397256992) | 13 | 9 | 11 | 29490 | 27 | ||
| 36681 | 22720 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 9 | 11 | 29490 | 41 | |||
| 38287 | 22723 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 3 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 9 | 11 | 29490 | 41 | |||
| 40439 | 2452 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1805X Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6003959.520066 | 2114567.2690482 | 37.7864223498862 | -122.430073076908 | (37.7864223498862, -122.430073076908) | 13 | 9 | 11 | 29490 | 13 | |||
| 44436 | 22716 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 8 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 9 | 11 | 29490 | 41 | |||
| 45498 | 22719 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 5 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 9 | 11 | 29490 | 41 | |||
| 62686 | 22722 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 9 | 11 | 29490 | 41 | |||
| 73540 | 22711 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 13 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 12 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 9 | 11 | 29490 | 41 | |||
| 89959 | 22721 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 3 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 9 | 11 | 29490 | 41 | |||
| 94050 | 6131 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 900X ELLIS ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6006542 | 2113585 | 37.7838712020833 | -122.421068560353 | (37.7838712020833, -122.421068560353) | 7 | 9 | 11 | 28858 | 41 | |||
| 94054 | 21691 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1881 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6003627.3299403 | 2114521.0871369 | 37.7862767266181 | -122.431219072895 | (37.7862767266181, -122.431219072895) | 13 | 9 | 11 | 29490 | 13 | |||
| 100106 | 7244 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1700 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 4x4 | 6003093.09301 | 2114182.05294 | 37.785315535228 | -122.433043161197 | (37.785315535228, -122.433043161197) | 13 | 9 | 11 | 29490 | 13 | |||
| 109108 | 21697 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1890 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6003576.7245218 | 2114564.5327129 | 37.7863931493079 | -122.431397256992 | (37.7863931493079, -122.431397256992) | 13 | 9 | 11 | 29490 | 27 | |||
| 112969 | 21752 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1787X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6002537.7996519 | 2114344.6571005 | 37.7857304915222 | -122.434975938446 | (37.7857304915222, -122.434975938446) | 13 | 9 | 11 | 29490 | 13 | |||
| 113644 | 22714 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 10 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 9 | 11 | 29490 | 41 | |||
| 121492 | 7292 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1895X Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6002963.99476 | 2114778.43194 | 37.7869457171278 | -122.433532436565 | (37.7869457171278, -122.433532436565) | 13 | 9 | 11 | 29490 | 27 | |||
| 137864 | 115903 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 201 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 4x4 | 6003287.79827449 | 2108952.35112135 | 37.7709671172915 | -122.431995967048 | (37.7709671172915, -122.431995967048) | 15 | 9 | 11 | 29492 | 9 | ||
| 149790 | 22717 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 7 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 9 | 11 | 29490 | 41 | |||
| 151636 | 20239 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1757X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6002551.4219946 | 2114246.4002369 | 37.7854614766008 | -122.434921779618 | (37.7854614766008, -122.434921779618) | 13 | 9 | 11 | 29490 | 13 | |||
| 155915 | 6134 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 900X Ellis St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6006541.37151 | 2113590.32225 | 37.7838857802496 | -122.421071112727 | (37.7838857802496, -122.421071112727) | 7 | 9 | 11 | 28858 | 41 | |||
| 156157 | 59335 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 201 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1980 12:00:00 AM | 4x4 | Permit Number 18682 | 6003287.79827449 | 2108952.35112135 | 37.7709671172915 | -122.431995967048 | (37.7709671172915, -122.431995967048) | 15 | 9 | 11 | 29492 | 9 | ||
| 156320 | 6133 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 900X ELLIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6006542 | 2113585 | 37.7838712020833 | -122.421068560353 | (37.7838712020833, -122.421068560353) | 7 | 9 | 11 | 28858 | 41 | |||
| 156870 | 21690 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1881 Sutter St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6003627.3299403 | 2114521.0871369 | 37.7862767266181 | -122.431219072895 | (37.7862767266181, -122.431219072895) | 13 | 9 | 11 | 29490 | 13 | |||
| 158341 | 1760 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3041X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6005500.29496 | 2120778.87447 | 37.8035649903432 | -122.425184535531 | (37.8035649903432, -122.425184535531) | 13 | 9 | 1 | 28858 | 17 | |||
| 161493 | 6285 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1480 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 6003867.05631 | 2113210.81806 | 37.7826926384963 | -122.43029616652 | (37.7826926384963, -122.43029616652) | 7 | 9 | 11 | 29490 | 41 | |||
| 182329 | 21698 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1890 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6003576.7245218 | 2114564.5327129 | 37.7863931493079 | -122.431397256992 | (37.7863931493079, -122.431397256992) | 13 | 9 | 11 | 29490 | 27 | |||
| 187443 | 22718 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 6 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 9 | 11 | 29490 | 41 | |||
| 187860 | 22712 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 12 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 9 | 11 | 29490 | 41 | |||
| 188273 | 2450 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1805X Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6003959.520066 | 2114567.2690482 | 37.7864223498862 | -122.430073076908 | (37.7864223498862, -122.430073076908) | 13 | 9 | 11 | 29490 | 13 | |||
| 7742 | 21626 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1610 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004833.69671 | 2114745.44523 | 37.7869610478907 | -122.427061339905 | (37.7869610478907, -122.427061339905) | 13 | 9 | 11 | 28858 | 27 | |||
| 10459 | 16731 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 19X Hollis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6003892.01293 | 2113485.99196 | 37.7834496108007 | -122.4302294651 | (37.7834496108007, -122.4302294651) | 7 | 9 | 11 | 29490 | 41 | |||
| 11809 | 7237 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1065 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003359.4574 | 2111944.18191 | 37.7791860077197 | -122.431961766737 | (37.7791860077197, -122.431961766737) | 15 | 9 | 11 | 29490 | 41 | |||
| 14444 | 7238 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1085 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4X4 | 6003353.84267 | 2112023.38614 | 37.7794031644909 | -122.431986847688 | (37.7794031644909, -122.431986847688) | 15 | 9 | 11 | 29490 | 41 | |||
| 20388 | 6375 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 309X Elm St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006152.1987649 | 2112618.7866796 | 37.7811962356475 | -122.422348456516 | (37.7811962356475, -122.422348456516) | 7 | 9 | 11 | 28852 | 41 | |||
| 20638 | 21644 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1657 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004676.7022509 | 2114666.9735246 | 37.7867367053745 | -122.427598912468 | (37.7867367053745, -122.427598912468) | 13 | 9 | 11 | 28858 | 13 | |||
| 21570 | 7202 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 926 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6003476.58431 | 2111463.23602 | 37.7778720892035 | -122.431522232661 | (37.7778720892035, -122.431522232661) | 15 | 9 | 11 | 29492 | 41 | |||
| 29320 | 21640 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1645 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6004732.1765743 | 2114674.6857014 | 37.7867610187213 | -122.427407534005 | (37.7867610187213, -122.427407534005) | 13 | 9 | 11 | 28858 | 13 | |||
| 29416 | 7261 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1727 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6003024.60166 | 2114236.6744 | 37.7854616266825 | -122.433284024643 | (37.7854616266825, -122.433284024643) | 13 | 9 | 11 | 29490 | 13 | |||
| 37545 | 21656 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1700 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004322.06269 | 2114670.60111 | 37.7867265999511 | -122.428826139996 | (37.7867265999511, -122.428826139996) | 13 | 9 | 11 | 29490 | 27 | |||
| 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 | |||
| 43983 | 10710 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 17X Hollis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003901.15311 | 2113362.61867 | 37.7831113762968 | -122.430189039187 | (37.7831113762968, -122.430189039187) | 7 | 9 | 11 | 29490 | 41 | |||
| 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 | |||
| 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 | ||
| 50280 | 7218 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000X Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.431717632161 | (37.778666518442, -122.431717632161) | 15 | 9 | 11 | 29490 | 41 | |||
| 52416 | 6378 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 310 Elm St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006136.3622128 | 2112667.0618885 | 37.7813278942368 | -122.422406674363 | (37.7813278942368, -122.422406674363) | 7 | 9 | 11 | 28852 | 41 | |||
| 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 | |||
| 60815 | 14812 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1190X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003455.90906 | 2111772.60341 | 37.7787203633271 | -122.431615848033 | (37.7787203633271, -122.431615848033) | 15 | 9 | 11 | 29490 | 41 | |||
| 61909 | 7229 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1040 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6003407.87597 | 2111884.23201 | 37.7790241450036 | -122.431789985507 | (37.7790241450036, -122.431789985507) | 15 | 9 | 11 | 29490 | 41 | |||
| 62512 | 21625 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1610 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004858.21198 | 2114748.18478 | 37.7869699562504 | -122.426976717781 | (37.7869699562504, -122.426976717781) | 13 | 9 | 11 | 28858 | 27 | |||
| 67395 | 20160 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1150X Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4X4 | 6002889.114145 | 2112192.180758 | 37.7798402749908 | -122.433606604391 | (37.7798402749908, -122.433606604391) | 15 | 9 | 11 | 29490 | 41 | |||
| 69526 | 9615 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1050X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6002927.21435 | 2111923.58629 | 37.7791049434867 | -122.433455599491 | (37.7791049434867, -122.433455599491) | 15 | 9 | 11 | 29490 | 41 | |||
| 74073 | 7223 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1234X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003286.8961 | 2111743.0712 | 37.7786296939692 | -122.432198419662 | (37.7786296939692, -122.432198419662) | 15 | 9 | 11 | 29490 | 41 | |||
| 74795 | 20161 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1150X Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4X4 | 6002889.114145 | 2112192.180758 | 37.7798402749908 | -122.433606604391 | (37.7798402749908, -122.433606604391) | 15 | 9 | 11 | 29490 | 41 | |||
| 75688 | 6379 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 310 Elm St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006136.3622128 | 2112667.0618885 | 37.7813278942368 | -122.422406674363 | (37.7813278942368, -122.422406674363) | 7 | 9 | 11 | 28852 | 41 | |||
| 78906 | 7228 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1040 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6003407.87597 | 2111884.23201 | 37.7790241450036 | -122.431789985507 | (37.7790241450036, -122.431789985507) | 15 | 9 | 11 | 29490 | 41 | |||
| 79190 | 7215 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.431717632161 | (37.778666518442, -122.431717632161) | 15 | 9 | 11 | 29490 | 41 | |||
| 81673 | 21749 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1840X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002560.9316389 | 2114541.9034523 | 37.786273393243 | -122.434910019678 | (37.786273393243, -122.434910019678) | 13 | 9 | 11 | 29490 | 27 | |||
| 82543 | 7221 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000X Fillmore St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.431717632161 | (37.778666518442, -122.431717632161) | 15 | 9 | 11 | 29490 | 41 |
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) );