trees
293 rows where Fire Prevention Districts = 13 and qSpecies_id = 54 sorted by rowid 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 193272 | 113486 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 30 PRESIDIO AVE | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998975 | 2116473 | 37.7913714231174 | -122.447455414162 | (37.7913714231174, -122.447455414162) | 13 | 6 | 1 | 29490 | 31 | ||||
| 193191 | 138110 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6004839.6037 | 2114746.6136 | 37.7869645899648 | -122.427040986298 | (37.7869645899648, -122.427040986298) | 13 | 9 | 11 | 28858 | 27 | |||
| 191265 | 143377 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1851 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004143.6971 | 2118693.4827 | 37.7977623133526 | -122.429730277572 | (37.7977623133526, -122.429730277572) | 13 | 9 | 1 | 57 | 17 | |||
| 191174 | 13286 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2599 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/16/1993 12:00:00 AM | 12 | 3X3 | 6000047.9587 | 2119131.9019 | 37.7987333214715 | -122.443934134594 | (37.7987333214715, -122.443934134594) | 13 | 9 | 1 | 57 | 17 | ||
| 190740 | 21590 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6005256.9547 | 2114799.289 | 37.7871328144412 | -122.425600795702 | (37.7871328144412, -122.425600795702) | 13 | 9 | 11 | 28858 | 27 | |||
| 190736 | 143523 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1931 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003741.1066 | 2118636.3409 | 37.7975826116174 | -122.431119270729 | (37.7975826116174, -122.431119270729) | 13 | 9 | 1 | 57 | 17 | |||
| 190419 | 113773 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1718 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x6 | 6000060.5464 | 2114943.4646 | 37.7872336928249 | -122.443589534945 | (37.7872336928249, -122.443589534945) | 13 | 6 | 1 | 29490 | 27 | |||
| 190035 | 143371 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1801 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004332.6549 | 2118719.4563 | 37.7978443281947 | -122.429078284228 | (37.7978443281947, -122.429078284228) | 13 | 9 | 1 | 57 | 17 | |||
| 186769 | 143518 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2162 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002654.3286 | 2118533.4904 | 37.797238567372 | -122.434872450071 | (37.797238567372, -122.434872450071) | 13 | 9 | 1 | 57 | 17 | |||
| 186726 | 143519 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2174 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002630.1383 | 2118528.26 | 37.7972228325878 | -122.434955780242 | (37.7972228325878, -122.434955780242) | 13 | 9 | 1 | 57 | 17 | |||
| 186282 | 138371 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6002611.3346 | 2114434.447 | 37.7859812067704 | -122.434727951803 | (37.7859812067704, -122.434727951803) | 13 | 9 | 11 | 29490 | 27 | |||
| 185736 | 138539 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1700 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003089.8085 | 2114203.6138 | 37.7853745495912 | -122.433056065597 | (37.7853745495912, -122.433056065597) | 13 | 9 | 11 | 29490 | 13 | |||
| 184520 | 113774 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1716 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 6000066.4859 | 2114892.9793 | 37.7870954120643 | -122.443565357608 | (37.7870954120643, -122.443565357608) | 13 | 6 | 1 | 29490 | 27 | |||
| 183591 | 138360 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6002847.7164 | 2114462.1983 | 37.7860708218731 | -122.433912120385 | (37.7860708218731, -122.433912120385) | 13 | 9 | 11 | 29490 | 27 | |||
| 182991 | 21588 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6005294.0011 | 2114805.6563 | 37.7871523906748 | -122.425473076473 | (37.7871523906748, -122.425473076473) | 13 | 9 | 11 | 28858 | 27 | |||
| 182903 | 21608 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1531 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/1990 12:00:00 AM | 12 | 4X4 | 6005005.2261 | 2114710.5754 | 37.7868750020607 | -122.42646540299 | (37.7868750020607, -122.42646540299) | 13 | 9 | 11 | 28858 | 13 | ||
| 181998 | 138373 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1801 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6002557.3186 | 2114515.2232 | 37.7861999309178 | -122.434920611081 | (37.7861999309178, -122.434920611081) | 13 | 9 | 11 | 29490 | 27 | |||
| 181651 | 59592 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1610 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1981 12:00:00 AM | 13 | Permit Number 18989 | 6000112.8301 | 2114568.7427 | 37.7862077855538 | -122.443381719167 | (37.7862077855538, -122.443381719167) | 13 | 6 | 1 | 29490 | 27 | ||
| 180620 | 143540 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2149 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002719.054 | 2118495.5705 | 37.7971381238315 | -122.434645771265 | (37.7971381238315, -122.434645771265) | 13 | 9 | 1 | 57 | 17 | |||
| 180014 | 138587 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1732 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000059.0615 | 2114952.3738 | 37.7872580704829 | -122.443595312613 | (37.7872580704829, -122.443595312613) | 13 | 6 | 1 | 29490 | 27 | |||
| 179783 | 106204 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600X Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 5x5 | 6003122.9413 | 2113972.2468 | 37.7847411535968 | -122.432924900964 | (37.7847411535968, -122.432924900964) | 13 | 9 | 11 | 29490 | 13 | |||
| 179434 | 143506 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1944 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003692.4061 | 2118683.7427 | 37.7977100049425 | -122.431291172811 | (37.7977100049425, -122.431291172811) | 13 | 9 | 1 | 57 | 17 | |||
| 178582 | 138502 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1799 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002532.1465 | 2114322.3247 | 37.7856688514425 | -122.434993898965 | (37.7856688514425, -122.434993898965) | 13 | 9 | 11 | 29490 | 13 | |||
| 178572 | 113276 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2129 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6002796.8552 | 2118506.6849 | 37.7971730575287 | -122.434377355222 | (37.7971730575287, -122.434377355222) | 13 | 9 | 1 | 57 | 17 | |||
| 177855 | 18050 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2832 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000363.8297 | 2114817.6224 | 37.7869054550264 | -122.442531204238 | (37.7869054550264, -122.442531204238) | 13 | 6 | 1 | 29490 | 27 | |||
| 177315 | 138475 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1749 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6003020.8355 | 2114339.7281 | 37.7857443724045 | -122.433304420865 | (37.7857443724045, -122.433304420865) | 13 | 9 | 11 | 29490 | 13 | |||
| 177164 | 13222 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2245 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001648.8811 | 2119355.19 | 37.7994376018224 | -122.438410445473 | (37.7994376018224, -122.438410445473) | 13 | 9 | 1 | 57 | 17 | |||
| 174812 | 143130 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2770 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5999261.9713 | 2119102.3163 | 37.7986072215669 | -122.44665176347 | (37.7986072215669, -122.44665176347) | 13 | 9 | 1 | 57 | 17 | |||
| 174777 | 13185 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2055X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002536.6029 | 2119475.0682 | 37.7998172097056 | -122.435347197327 | (37.7998172097056, -122.435347197327) | 13 | 9 | 1 | 57 | 17 | |||
| 174467 | 143349 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1651 UNION ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005080.6941 | 2118822.052 | 37.7981683451252 | -122.426497166568 | (37.7981683451252, -122.426497166568) | 13 | 9 | 1 | 57 | 17 | |||
| 174365 | 21629 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1615 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/1994 12:00:00 AM | 12 | 4X4 | 6004674.0893 | 2114666.9174 | 37.7867364034737 | -122.427607948661 | (37.7867364034737, -122.427607948661) | 13 | 9 | 11 | 28858 | 13 | ||
| 174010 | 21712 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1900 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6x8 | 6003372.5799 | 2114537.2521 | 37.7863066717407 | -122.432101596345 | (37.7863066717407, -122.432101596345) | 13 | 9 | 11 | 29490 | 27 | |||
| 172387 | 143338 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1862 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004088.5033 | 2118729.1964 | 37.797857248461 | -122.429923812172 | (37.797857248461, -122.429923812172) | 13 | 9 | 1 | 57 | 17 | |||
| 172102 | 21739 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2045 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002859.7063 | 2114412.7642 | 37.785935768772 | -122.433867103908 | (37.785935768772, -122.433867103908) | 13 | 9 | 11 | 29490 | 13 | |||
| 170781 | 21586 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6005346.0976 | 2114810.866 | 37.7871696385608 | -122.425293204645 | (37.7871696385608, -122.425293204645) | 13 | 9 | 11 | 28858 | 27 | |||
| 168368 | 112635 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1715 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6000531.3846 | 2114698.9549 | 37.7865891741887 | -122.441942983766 | (37.7865891741887, -122.441942983766) | 13 | 6 | 1 | 29490 | 27 | |||
| 167935 | 18023 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2729 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000744.2415 | 2114813.5523 | 37.7869159561343 | -122.441214778061 | (37.7869159561343, -122.441214778061) | 13 | 6 | 1 | 29490 | 27 | |||
| 167816 | 138091 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1890 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/1990 12:00:00 AM | 15 | Width 0ft | 6003632 | 2114586 | 37.7864552256154 | -122.431207550794 | (37.7864552256154, -122.431207550794) | 13 | 9 | 11 | 29490 | 27 | ||
| 166387 | 141766 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1529 O'Farrell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003866.9642 | 2113516.1114 | 37.783530892448 | -122.430318273506 | (37.783530892448, -122.430318273506) | 13 | 9 | 11 | 29490 | 41 | |||
| 165725 | 253907 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2807 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/05/2018 12:00:00 AM | 3 | 3X3 | 6000402 | 2114746 | 37.7867109741586 | -122.442394000297 | (37.7867109741586, -122.442394000297) | 13 | 6 | 1 | 29490 | 27 | ||
| 165716 | 143544 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2167 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6002631.4459 | 2118483.1484 | 37.7970990421024 | -122.434948027724 | (37.7970990421024, -122.434948027724) | 13 | 9 | 1 | 57 | 17 | |||
| 165239 | 143350 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1651 UNION ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6005097.577 | 2118824.6493 | 37.7981764310334 | -122.426438931744 | (37.7981764310334, -122.426438931744) | 13 | 9 | 1 | 57 | 17 | |||
| 164335 | 138504 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2199 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002136.009 | 2114306.6228 | 37.7856032373843 | -122.436363294657 | (37.7856032373843, -122.436363294657) | 13 | 6 | 11 | 29490 | 13 | |||
| 162803 | 18018 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2718 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000772 | 2114884 | 37.7871109684575 | -122.441123796433 | (37.7871109684575, -122.441123796433) | 13 | 6 | 1 | 29490 | 27 | |||
| 162662 | 13291 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2671 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 1X1 | 5999604.2969 | 2119102.6495 | 37.7986276847794 | -122.445467237046 | (37.7986276847794, -122.445467237046) | 13 | 9 | 1 | 57 | 17 | |||
| 160555 | 143341 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1836 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004187.8522 | 2118745.4299 | 37.7979074472164 | -122.429581195466 | (37.7979074472164, -122.429581195466) | 13 | 9 | 1 | 57 | 17 | |||
| 160372 | 143516 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2074 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003069.4862 | 2118592.3316 | 37.7974236924258 | -122.433440108539 | (37.7974236924258, -122.433440108539) | 13 | 9 | 1 | 57 | 17 | |||
| 159925 | 13113 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1611 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6004587.0591 | 2119767.9005 | 37.8007374842012 | -122.428272736084 | (37.8007374842012, -122.428272736084) | 13 | 9 | 1 | 57 | 17 | |||
| 159684 | 142820 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1754 POLK ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 0ft | 6006598.3556 | 2116937.7026 | 37.7930800716409 | -122.421111730561 | (37.7930800716409, -122.421111730561) | 13 | 9 | 10 | 28858 | 32 | |||
| 159445 | 58051 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1609 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/1977 12:00:00 AM | 5 | Permit Number 17020 | 6006619.5836 | 2116449.4594 | 37.7917406740828 | -122.421003598405 | (37.7917406740828, -122.421003598405) | 13 | 9 | 10 | 28858 | 21 | ||
| 158536 | 138588 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1732 BAKER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000056.8342 | 2114968.7073 | 37.7873027909955 | -122.443604192363 | (37.7873027909955, -122.443604192363) | 13 | 6 | 1 | 29490 | 27 | |||
| 156517 | 138119 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1700 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x7 | 6004323.0329 | 2114669.3641 | 37.786723258345 | -122.42882269508 | (37.786723258345, -122.42882269508) | 13 | 9 | 11 | 29490 | 27 | |||
| 156375 | 143542 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2163 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002663.4817 | 2118487.0712 | 37.7971116319851 | -122.434837456805 | (37.7971116319851, -122.434837456805) | 13 | 9 | 1 | 57 | 17 | |||
| 156150 | 143125 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2095 LOMBARD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002486.7834 | 2119470.709 | 37.7998024110973 | -122.435519279075 | (37.7998024110973, -122.435519279075) | 13 | 9 | 1 | 57 | 17 | |||
| 155990 | 138472 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1749 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6003013.5126 | 2114389.5238 | 37.785880683353 | -122.433333315539 | (37.785880683353, -122.433333315539) | 13 | 9 | 11 | 29490 | 13 | |||
| 155058 | 21710 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1900 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6003404.4442 | 2114543.7174 | 37.7863262303196 | -122.431991815976 | (37.7863262303196, -122.431991815976) | 13 | 9 | 11 | 29490 | 27 | |||
| 154329 | 143533 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2095 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002997.5691 | 2118532.1828 | 37.797254458986 | -122.433684659132 | (37.797254458986, -122.433684659132) | 13 | 9 | 1 | 57 | 17 | |||
| 154099 | 21657 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1725 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6004318.093 | 2114616.1002 | 37.7865767294467 | -122.428835987308 | (37.7865767294467, -122.428835987308) | 13 | 9 | 11 | 29490 | 13 | |||
| 153768 | 13109 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1599 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1994 12:00:00 AM | 24 | 3x3 | 6004827.8666 | 2119796.0468 | 37.8008283892799 | -122.427441448129 | (37.8008283892799, -122.427441448129) | 13 | 9 | 1 | 57 | 17 | ||
| 151766 | 138121 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1980 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003117.6649 | 2114503.0787 | 37.7861983845046 | -122.43298109352 | (37.7861983845046, -122.43298109352) | 13 | 9 | 11 | 29490 | 27 | |||
| 151675 | 13111 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1599 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/1994 12:00:00 AM | 24 | 3X3 | 6004886.5048 | 2119803.0834 | 37.8008510262732 | -122.4272390368 | (37.8008510262732, -122.4272390368) | 13 | 9 | 1 | 57 | 17 | ||
| 151305 | 31653 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1708 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1995 12:00:00 AM | 8 | Permit Number 35163 | 6004466.8826 | 2114789.0769 | 37.7870601003628 | -122.428333544653 | (37.7870601003628, -122.428333544653) | 13 | 9 | 11 | 28858 | 27 | ||
| 150683 | 138506 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1701 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003039.875 | 2114221.8295 | 37.7854217327846 | -122.43323012237 | (37.7854217327846, -122.43323012237) | 13 | 9 | 11 | 29490 | 13 | |||
| 150365 | 21589 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Sutter St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6005274.899 | 2114802.7621 | 37.7871433646236 | -122.425538959573 | (37.7871433646236, -122.425538959573) | 13 | 9 | 11 | 28858 | 27 | |||
| 150049 | 7258 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1714 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6003084.9119 | 2114241.8074 | 37.7854791418066 | -122.433075736157 | (37.7854791418066, -122.433075736157) | 13 | 9 | 11 | 29490 | 13 | |||
| 149913 | 7259 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1718 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6003082.9532 | 2114267.2697 | 37.7855489437372 | -122.433084332552 | (37.7855489437372, -122.433084332552) | 13 | 9 | 11 | 29490 | 13 | |||
| 149305 | 2590 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1712 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 6005179.844 | 2115138.5122 | 37.7880598792815 | -122.425891737823 | (37.7880598792815, -122.425891737823) | 13 | 9 | 11 | 28858 | 27 | |||
| 148870 | 143348 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1651 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6005062.5126 | 2118820.104 | 37.7981619685874 | -122.426559941179 | (37.7981619685874, -122.426559941179) | 13 | 9 | 1 | 57 | 17 | |||
| 148681 | 26166 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1501 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6005131.2215 | 2119837.4845 | 37.8009593191179 | -122.426394664407 | (37.8009593191179, -122.426394664407) | 13 | 9 | 1 | 57 | 17 | |||
| 148555 | 2728 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2250 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002761.9846 | 2114804.6298 | 37.7870061862481 | -122.434233218569 | (37.7870061862481, -122.434233218569) | 13 | 9 | 11 | 29490 | 27 | |||
| 147923 | 143522 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2230 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6002288.2054 | 2118479.2257 | 37.7970687767232 | -122.436135441431 | (37.7970687767232, -122.436135441431) | 13 | 9 | 1 | 57 | 17 | |||
| 146752 | 13269 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2495 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 6 | 3X3 | 6000559.8762 | 2119201.7827 | 37.7989543831909 | -122.442167759467 | (37.7989543831909, -122.442167759467) | 13 | 9 | 1 | 57 | 17 | ||
| 146663 | 138040 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1 Wilmot St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003385.4026 | 2115029.2516 | 37.7876583048425 | -122.432092380369 | (37.7876583048425, -122.432092380369) | 13 | 9 | 11 | 29490 | 27 | |||
| 145855 | 21673 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1781 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6004071.937 | 2114582.0596 | 37.786469327183 | -122.429685197969 | (37.786469327183, -122.429685197969) | 13 | 9 | 11 | 29490 | 13 | |||
| 145453 | 138719 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1715 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000532.2571 | 2114677.58 | 37.7865305339642 | -122.441938430381 | (37.7865305339642, -122.441938430381) | 13 | 6 | 1 | 29490 | 27 | |||
| 140995 | 143144 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2150 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6002035.2938 | 2119489.3913 | 37.7998280549764 | -122.437082936374 | (37.7998280549764, -122.437082936374) | 13 | 9 | 1 | 57 | 17 | |||
| 140588 | 143370 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1775 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004517.0674 | 2118744.1312 | 37.7979225163272 | -122.428441924861 | (37.7979225163272, -122.428441924861) | 13 | 9 | 1 | 57 | 17 | |||
| 139785 | 7265 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1740 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003066.7944 | 2114355.8984 | 37.7857913791158 | -122.433146572029 | (37.7857913791158, -122.433146572029) | 13 | 9 | 11 | 29490 | 13 | |||
| 139504 | 138180 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 42 ORBEN PL | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003159.9004 | 2115394.1683 | 37.788647485977 | -122.432898653615 | (37.788647485977, -122.432898653615) | 13 | 9 | 1 | 29490 | 27 | |||
| 139500 | 143141 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2140 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6002153.6152 | 2119503.7145 | 37.7998741075374 | -122.436674526744 | (37.7998741075374, -122.436674526744) | 13 | 9 | 1 | 57 | 17 | |||
| 138988 | 137859 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 20 Orben Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003149.2963 | 2115462.6131 | 37.7888348165279 | -122.432940234026 | (37.7888348165279, -122.432940234026) | 13 | 9 | 1 | 29490 | 27 | |||
| 137177 | 138500 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2416 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6001920.8461 | 2114683.7924 | 37.7866266207317 | -122.437134708687 | (37.7866266207317, -122.437134708687) | 13 | 6 | 11 | 29490 | 27 | |||
| 135488 | 138471 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1749 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6003013.5126 | 2114407.0987 | 37.7859289395771 | -122.433334571847 | (37.7859289395771, -122.433334571847) | 13 | 9 | 11 | 29490 | 13 | |||
| 135464 | 138678 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2811 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000338.1385 | 2114753.4825 | 37.7867278790367 | -122.442615482645 | (37.7867278790367, -122.442615482645) | 13 | 6 | 1 | 29490 | 27 | |||
| 135059 | 143376 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1847 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004159.9306 | 2118694.7814 | 37.7977667984644 | -122.429674197856 | (37.7977667984644, -122.429674197856) | 13 | 9 | 1 | 57 | 17 | |||
| 134472 | 143517 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2084 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003028.2973 | 2118586.4475 | 37.797405199304 | -122.433582211996 | (37.797405199304, -122.433582211996) | 13 | 9 | 1 | 57 | 17 | |||
| 133538 | 143367 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1757 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004589.7934 | 2118755.8193 | 37.7979587239783 | -122.428191105617 | (37.7979587239783, -122.428191105617) | 13 | 9 | 1 | 57 | 17 | |||
| 132419 | 143353 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1651 UNION ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005181.3418 | 2118836.9868 | 37.7982150414331 | -122.426149959367 | (37.7982150414331, -122.426149959367) | 13 | 9 | 1 | 57 | 17 | |||
| 132269 | 143342 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1836 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004176.1641 | 2118743.4819 | 37.7979014367097 | -122.429621500594 | (37.7979014367097, -122.429621500594) | 13 | 9 | 1 | 57 | 17 | |||
| 131660 | 13110 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1599 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1994 12:00:00 AM | 16 | 3x3 | 6004846.6308 | 2119801.5197 | 37.800844477708 | -122.427376906198 | (37.800844477708, -122.427376906198) | 13 | 9 | 1 | 57 | 17 | ||
| 131039 | 18012 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2707 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6000934.1764 | 2114843.3331 | 37.787008543855 | -122.440559785253 | (37.787008543855, -122.440559785253) | 13 | 6 | 1 | 29490 | 27 | |||
| 130915 | 138361 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 0ft | 6002830.8674 | 2114461.7028 | 37.7860685051903 | -122.433970377911 | (37.7860685051903, -122.433970377911) | 13 | 9 | 11 | 29490 | 27 | |||
| 130807 | 21632 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1615 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/04/1991 12:00:00 AM | 12 | 4X4 | 6004741.4911 | 2114677.6404 | 37.7867696583856 | -122.427375518495 | (37.7867696583856, -122.427375518495) | 13 | 9 | 11 | 28858 | 13 | ||
| 129005 | 106207 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600X Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 5x5 | 6003107.6347 | 2114075.5662 | 37.7850239743837 | -122.43298524084 | (37.7850239743837, -122.43298524084) | 13 | 9 | 11 | 29490 | 13 | |||
| 127146 | 143364 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1892 UNION ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003944.3499 | 2118711.0149 | 37.7977991621229 | -122.430421325358 | (37.7977991621229, -122.430421325358) | 13 | 9 | 1 | 57 | 17 | |||
| 126799 | 143137 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2677 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999556.3554 | 2119096.149 | 37.7986070991836 | -122.445632661504 | (37.7986070991836, -122.445632661504) | 13 | 9 | 1 | 57 | 17 | |||
| 126352 | 138124 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1850 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003031.7696 | 2114609.7551 | 37.7864864184254 | -122.433285893848 | (37.7864864184254, -122.433285893848) | 13 | 9 | 11 | 29490 | 27 | |||
| 125638 | 13093 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1450 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6005391.575 | 2119956.3245 | 37.8013003370098 | -122.42550219218 | (37.8013003370098, -122.42550219218) | 13 | 9 | 1 | 57 | 17 | |||
| 124838 | 143343 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1846 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6004153.4372 | 2118740.8845 | 37.797893018043 | -122.429699956736 | (37.797893018043, -122.429699956736) | 13 | 9 | 1 | 57 | 17 | |||
| 124613 | 18036 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2807 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000406.6253 | 2114762.207 | 37.7867557380075 | -122.442379161867 | (37.7867557380075, -122.442379161867) | 13 | 6 | 1 | 29490 | 27 |
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) );