trees
293 rows where Fire Prevention Districts = 13 and qSpecies_id = 54 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
311 | 138787 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2714 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6000799 | 2114887 | 37.7871207435599 | -122.441030597921 | (37.7871207435599, -122.441030597921) | 13 | 6 | 1 | 29490 | 27 | |||
1388 | 49516 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1910 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Permit Number 46422 | 6002507.7627 | 2114881.9371 | 37.7872040200664 | -122.435118299397 | (37.7872040200664, -122.435118299397) | 13 | 9 | 11 | 29490 | 27 | |||
2251 | 143510 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2026 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2006 12:00:00 AM | 14 | Width 0ft | Permit Number 48982 | 6003323.1573 | 2118630.9053 | 37.797543994409 | -122.432565097779 | (37.797543994409, -122.432565097779) | 13 | 9 | 1 | 57 | 17 | |
3502 | 138641 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2760 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2020 12:00:00 AM | 3 | Width 0ft | 6000298.8786 | 2114459.033 | 37.7859171589985 | -122.442730161492 | (37.7859171589985, -122.442730161492) | 13 | 6 | 1 | 29490 | 27 | ||
3546 | 138584 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2702 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6000961.2488 | 2114897.5694 | 37.7871590042849 | -122.440470012407 | (37.7871590042849, -122.440470012407) | 13 | 6 | 1 | 29490 | 27 | |||
6829 | 62365 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2132 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/1985 12:00:00 AM | 14 | 6x4 | Permit Number 22511 | 6002365.7866 | 2114401.6807 | 37.7858772955002 | -122.43557513482 | (37.7858772955002, -122.43557513482) | 13 | 6 | 1 | 29490 | 27 | |
7900 | 138130 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2145 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003041.4675 | 2114785.2401 | 37.7869688058807 | -122.433264885414 | (37.7869688058807, -122.433264885414) | 13 | 9 | 11 | 29490 | 27 | |||
8308 | 143512 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2030 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2006 12:00:00 AM | 16 | Width 0ft | Permit Number 48982 | 6003288.5063 | 2118622.406 | 37.7975186924595 | -122.432684391924 | (37.7975186924595, -122.432684391924) | 13 | 9 | 1 | 57 | 17 | |
8801 | 138109 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6004876.0712 | 2114750.6655 | 37.7869777775164 | -122.426915105637 | (37.7869777775164, -122.426915105637) | 13 | 9 | 11 | 28858 | 27 | |||
13989 | 137919 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1963 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004551.2938 | 2115340.9969 | 37.788580310137 | -122.428080846949 | (37.788580310137, -122.428080846949) | 13 | 9 | 11 | 28858 | 27 | |||
14320 | 143346 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1910 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003772.2749 | 2118686.9893 | 37.7977234452078 | -122.431015036831 | (37.7977234452078, -122.431015036831) | 13 | 9 | 1 | 57 | 17 | |||
14805 | 143525 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1957 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003628.1215 | 2118621.4061 | 37.7975352014281 | -122.43150916251 | (37.7975352014281, -122.43150916251) | 13 | 9 | 1 | 57 | 17 | |||
16934 | 143369 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1763 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004565.1185 | 2118753.222 | 37.7979501963148 | -122.428276302626 | (37.7979501963148, -122.428276302626) | 13 | 9 | 1 | 57 | 17 | |||
23537 | 143389 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1800 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004330.7069 | 2118766.2088 | 37.7979725882879 | -122.429088360064 | (37.7979725882879, -122.429088360064) | 13 | 9 | 1 | 57 | 17 | |||
23778 | 21585 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6005366.3574 | 2114813.7602 | 37.7871787298771 | -122.425223316098 | (37.7871787298771, -122.425223316098) | 13 | 9 | 11 | 28858 | 27 | |||
24167 | 31656 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1708 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1995 12:00:00 AM | 9 | 3x3 | Permit Number 35163 | 6004478.3831 | 2114720.074 | 37.7868712864461 | -122.428288835726 | (37.7868712864461, -122.428288835726) | 13 | 9 | 11 | 28858 | 27 | |
24735 | 137798 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1900 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004365.9463 | 2115528.293 | 37.7890840898669 | -122.428735478435 | (37.7890840898669, -122.428735478435) | 13 | 9 | 11 | 28858 | 27 | |||
25242 | 142827 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1714 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6006619.3625 | 2116773.8493 | 37.7926313555217 | -122.421027406021 | (37.7926313555217, -122.421027406021) | 13 | 9 | 10 | 28858 | 32 | |||
26277 | 138359 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6002861.592 | 2114464.6761 | 37.7860784126894 | -122.433864291751 | (37.7860784126894, -122.433864291751) | 13 | 9 | 11 | 29490 | 27 | |||
27215 | 13203 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2143 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002126.2145 | 2119425.2487 | 37.7996571038373 | -122.436763723295 | (37.7996571038373, -122.436763723295) | 13 | 9 | 1 | 57 | 17 | |||
27696 | 53066 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2161 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2006 12:00:00 AM | 4 | Permit Number 49038 | 6002280.6463 | 2114328.4092 | 37.7856712745428 | -122.435864451687 | (37.7856712745428, -122.435864451687) | 13 | 6 | 11 | 29490 | 13 | ||
27911 | 121250 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 31 Orben Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x3 | Permit Number 778957 | 6003136.4072 | 2115361.6956 | 37.7885569916775 | -122.432977615629 | (37.7885569916775, -122.432977615629) | 13 | 9 | 1 | 29490 | 27 | ||
28509 | 13126 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1701 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X3 | 6004190.6649 | 2119706.135 | 37.8005454550984 | -122.429640016754 | (37.8005454550984, -122.429640016754) | 13 | 9 | 1 | 57 | 17 | |||
29027 | 65538 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2180 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/1990 12:00:00 AM | 16 | 6x6 | Permit Number 28435 | 6002182.4791 | 2114372.5672 | 37.7857869442252 | -122.436207242735 | (37.7857869442252, -122.436207242735) | 13 | 6 | 1 | 29490 | 27 |
29405 | 21724 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1942X Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/27/2003 12:00:00 AM | 17 | 4X4 | 6003291.3026 | 2114524.3217 | 37.786266559771 | -122.432381870835 | (37.786266559771, -122.432381870835) | 13 | 9 | 11 | 29490 | 27 | ||
30976 | 143334 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1820 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004249.5395 | 2118755.17 | 37.7979376836352 | -122.429368434888 | (37.7979376836352, -122.429368434888) | 13 | 9 | 1 | 57 | 17 | |||
31175 | 7267 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1750 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003061.8978 | 2114394.5816 | 37.7858973156258 | -122.433166277822 | (37.7858973156258, -122.433166277822) | 13 | 9 | 11 | 29490 | 13 | |||
33318 | 66182 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1819 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/06/1990 12:00:00 AM | 12 | Permit Number 29259 | 6004371.7533 | 2115130.5363 | 37.7879922787707 | -122.428687021207 | (37.7879922787707, -122.428687021207) | 13 | 9 | 11 | 29490 | 27 | ||
34430 | 13280 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2524 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/15/1993 12:00:00 AM | 40 | 3X3 | 6000256.3025 | 2119240.7621 | 37.7990441048198 | -122.443221023077 | (37.7990441048198, -122.443221023077) | 13 | 9 | 1 | 57 | 17 | ||
34586 | 143521 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2224 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6002337.2397 | 2118485.1098 | 37.7970877186103 | -122.435966192289 | (37.7970877186103, -122.435966192289) | 13 | 9 | 1 | 57 | 17 | |||
36350 | 137858 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 22 Orben Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003153.1523 | 2115433.6928 | 37.7887556274538 | -122.43292482586 | (37.7887556274538, -122.43292482586) | 13 | 9 | 1 | 29490 | 27 | |||
36803 | 143527 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1979 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003537.8633 | 2118608.4193 | 37.7974944269949 | -122.431820551935 | (37.7974944269949, -122.431820551935) | 13 | 9 | 1 | 57 | 17 | |||
37114 | 13143 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1800 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6003680.9036 | 2119717.0807 | 37.8005466318744 | -122.431404778789 | (37.8005466318744, -122.431404778789) | 13 | 9 | 1 | 57 | 17 | |||
37814 | 13181 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2001 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002704.7439 | 2119503.7145 | 37.7999054122901 | -122.434767417241 | (37.7999054122901, -122.434767417241) | 13 | 9 | 1 | 57 | 17 | |||
38110 | 138007 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1803 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003877.7864 | 2114559.3667 | 37.7863960226531 | -122.430355290708 | (37.7863960226531, -122.430355290708) | 13 | 9 | 11 | 29490 | 13 | |||
38247 | 21606 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1525 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6005078.2447 | 2114724.3621 | 37.7869169843519 | -122.426213757225 | (37.7869169843519, -122.426213757225) | 13 | 9 | 11 | 28858 | 13 | |||
41667 | 56934 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1923 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 16 | 3x3 | Permit Number 14180 | 6001934.7565 | 2115177.2253 | 37.7879822517226 | -122.437121923696 | (37.7879822517226, -122.437121923696) | 13 | 6 | 1 | 29490 | 27 | |
41892 | 138372 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1801 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002563.7609 | 2114481.5252 | 37.7861077705586 | -122.434895911649 | (37.7861077705586, -122.434895911649) | 13 | 9 | 11 | 29490 | 27 | |||
43116 | 18005 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2683 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001144.5248 | 2114870.2639 | 37.7870944645688 | -122.439833960351 | (37.7870944645688, -122.439833960351) | 13 | 6 | 1 | 29490 | 27 | |||
43362 | 13125 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1688 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 25 | 3X3 | 6004309.8631 | 2119808.6849 | 37.8008337792511 | -122.429234859067 | (37.8008337792511, -122.429234859067) | 13 | 9 | 1 | 57 | 17 | ||
44948 | 143136 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2679 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5999509.2265 | 2119087.2107 | 37.7985798662052 | -122.445795098614 | (37.7985798662052, -122.445795098614) | 13 | 9 | 1 | 57 | 17 | |||
45477 | 138501 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1799 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002528.8099 | 2114345.6813 | 37.7857327932764 | -122.435007113669 | (37.7857327932764, -122.435007113669) | 13 | 9 | 11 | 29490 | 13 | |||
46246 | 143537 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2125 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002811.2386 | 2118507.9925 | 37.7971774642757 | -122.434327678668 | (37.7971774642757, -122.434327678668) | 13 | 9 | 1 | 57 | 17 | |||
47498 | 143390 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1806 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004317.0708 | 2118762.9621 | 37.7979629017809 | -122.429135313255 | (37.7979629017809, -122.429135313255) | 13 | 9 | 1 | 57 | 17 | |||
49426 | 137887 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 38 ORBEN PL | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003163.7564 | 2115374.888 | 37.788594765883 | -122.432883934493 | (37.788594765883, -122.432883934493) | 13 | 9 | 1 | 29490 | 27 | |||
51393 | 137896 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1832 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6004416.1912 | 2115174.8872 | 37.7881165700494 | -122.428536436558 | (37.7881165700494, -122.428536436558) | 13 | 9 | 11 | 28858 | 27 | |||
51830 | 13226 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2265 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 6001595.9478 | 2119347.0943 | 37.7994123621689 | -122.438593032687 | (37.7994123621689, -122.438593032687) | 13 | 9 | 1 | 57 | 17 | ||||
52736 | 13161 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1895 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 6003359.5664 | 2119590.4223 | 37.8001806439695 | -122.432507683341 | (37.8001806439695, -122.432507683341) | 13 | 9 | 1 | 57 | 17 | |||
54460 | 54103 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2317 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1972 12:00:00 AM | 3x3 | Permit Number 9832 | 6003101.11509235 | 2116824.39264322 | 37.7925711821936 | -122.433204275613 | (37.7925711821936, -122.433204275613) | 13 | 9 | 1 | 29490 | 27 | ||
55174 | 60217 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2100 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1982 12:00:00 AM | 15 | 3x3 | Permit Number 19767 | 6002507.5803 | 2114417.8549 | 37.7859297581806 | -122.43508572581 | (37.7859297581806, -122.43508572581) | 13 | 6 | 1 | 29490 | 27 | |
56354 | 143526 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1969 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003606.6933 | 2118620.1074 | 37.7975304210104 | -122.431583216972 | (37.7975304210104, -122.431583216972) | 13 | 9 | 1 | 57 | 17 | |||
56486 | 65627 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2116 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1990 12:00:00 AM | 12 | 6x6 | Permit Number 28535 | 6002451.5098 | 2114409.7678 | 37.7859043690694 | -122.435279135393 | (37.7859043690694, -122.435279135393) | 13 | 6 | 1 | 29490 | 27 |
58460 | 138112 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1698 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6004508.5013 | 2114699.1479 | 37.7868155327596 | -122.428183141793 | (37.7868155327596, -122.428183141793) | 13 | 9 | 11 | 28858 | 27 | |||
58688 | 66506 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2458 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | 15 | Permit Number 29669 | 6001738.4652 | 2114659.4492 | 37.7865494118178 | -122.43776395706 | (37.7865494118178, -122.43776395706) | 13 | 6 | 11 | 29490 | 27 | |
59474 | 49435 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1919 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2003 12:00:00 AM | 8 | Permit Number 46373 | 6001939.0069 | 2115153.2685 | 37.7879167140987 | -122.437105502206 | (37.7879167140987, -122.437105502206) | 13 | 6 | 1 | 29490 | 27 | ||
60753 | 58122 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 24 Orben Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1978 12:00:00 AM | 13 | Permit Number 17103 | 6003170.2635 | 2115307.1662 | 37.7884091881086 | -122.432856580985 | (37.7884091881086, -122.432856580985) | 13 | 9 | 1 | 29490 | 27 | ||
61568 | 138417 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2158 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6002253.1064 | 2114381.7326 | 37.7858161225558 | -122.435963548588 | (37.7858161225558, -122.435963548588) | 13 | 6 | 1 | 29490 | 27 | |||
62701 | 137986 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1826 WEBSTER ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 0ft | 6003453.629 | 2115096.2902 | 37.7878462437049 | -122.431861119013 | (37.7878462437049, -122.431861119013) | 13 | 9 | 11 | 29490 | 27 | |||
63070 | 92953 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1338 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6006789.4485 | 2115574.9476 | 37.7893490550841 | -122.420353767408 | (37.7893490550841, -122.420353767408) | 13 | 9 | 10 | 28858 | 21 | ||||
67787 | 143524 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2240 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002241.7862 | 2118472.6878 | 37.7970481880141 | -122.436295594804 | (37.7970481880141, -122.436295594804) | 13 | 9 | 1 | 57 | 17 | |||
67847 | 143515 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2072 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003081.9082 | 2118594.9468 | 37.7974315778327 | -122.433397312199 | (37.7974315778327, -122.433397312199) | 13 | 9 | 1 | 57 | 17 | |||
68312 | 138537 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1700 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003095.1947 | 2114174.7238 | 37.7852955304758 | -122.433035366169 | (37.7852955304758, -122.433035366169) | 13 | 9 | 11 | 29490 | 13 | |||
68359 | 21709 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1900 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x9 | 6003440.4648 | 2114551.568 | 37.7863498280943 | -122.431867754773 | (37.7863498280943, -122.431867754773) | 13 | 9 | 11 | 29490 | 27 | |||
68680 | 106203 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5x5 | 6003127.4057 | 2113944.8226 | 37.7846661068828 | -122.432907495725 | (37.7846661068828, -122.432907495725) | 13 | 9 | 11 | 29490 | 13 | |||
71734 | 18009 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2704 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6000887.4934 | 2114883.9407 | 37.7871173834408 | -122.440724211427 | (37.7871173834408, -122.440724211427) | 13 | 6 | 1 | 29490 | 27 | |||
72034 | 92952 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1334 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6006791.0528 | 2115558.9055 | 37.789305097845 | -122.420347077615 | (37.789305097845, -122.420347077615) | 13 | 9 | 10 | 28858 | 21 | ||||
73860 | 137987 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1815 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004374.8136 | 2115107.5838 | 37.7879294301748 | -122.428674796307 | (37.7879294301748, -122.428674796307) | 13 | 9 | 11 | 29490 | 27 | |||
74356 | 143530 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2198 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6002524.2241 | 2118512.569 | 37.797173734939 | -122.435321146522 | (37.797173734939, -122.435321146522) | 13 | 9 | 1 | 57 | 17 | |||
75544 | 143539 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2133 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6002781.8179 | 2118502.7622 | 37.7971614332575 | -122.434429107355 | (37.7971614332575, -122.434429107355) | 13 | 9 | 1 | 57 | 17 | |||
75736 | 143545 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2165 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002649.7521 | 2118486.4174 | 37.7971090573089 | -122.434884917759 | (37.7971090573089, -122.434884917759) | 13 | 9 | 1 | 57 | 17 | |||
78131 | 18011 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2707 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6000900.4249 | 2114838.7005 | 37.7869939019534 | -122.440676225149 | (37.7869939019534, -122.440676225149) | 13 | 6 | 1 | 29490 | 27 | |||
81789 | 98493 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1703 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | 6006578.8967 | 2116733.3834 | 37.7925179651008 | -122.421164544764 | (37.7925179651008, -122.421164544764) | 13 | 9 | 10 | 28858 | 32 | ||||
83890 | 57820 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2357 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/1977 12:00:00 AM | 11 | Permit Number 16759 | 6002204.3143 | 2114668.0157 | 37.7865994109848 | -122.436152849525 | (37.7865994109848, -122.436152849525) | 13 | 6 | 1 | 29490 | 27 | ||
84974 | 13190 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2095 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6002390.8808 | 2119455.1404 | 37.7997542165181 | -122.435850022657 | (37.7997542165181, -122.435850022657) | 13 | 9 | 1 | 57 | 17 | ||
85092 | 138010 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1401 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005424.6122 | 2114535.843 | 37.7864189291949 | -122.425001985822 | (37.7864189291949, -122.425001985822) | 13 | 9 | 11 | 28858 | 13 | |||
88028 | 13184 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2055X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002517.9206 | 2119475.0682 | 37.7998161487163 | -122.435411844948 | (37.7998161487163, -122.435411844948) | 13 | 9 | 1 | 57 | 17 | |||
88396 | 7257 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1714 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6003087.8498 | 2114225.1589 | 37.785433595884 | -122.433064381988 | (37.785433595884, -122.433064381988) | 13 | 9 | 11 | 29490 | 13 | |||
88515 | 143357 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1944 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003704.7436 | 2118683.7427 | 37.797710704116 | -122.431248481701 | (37.797710704116, -122.431248481701) | 13 | 9 | 1 | 57 | 17 | |||
91946 | 13112 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1601 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3x3 | 6004666.807 | 2119779.6281 | 37.8007741971938 | -122.42799761136 | (37.8007741971938, -122.42799761136) | 13 | 9 | 1 | 57 | 17 | |||
93784 | 17999 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2663 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001215.9923 | 2114878.7551 | 37.7871218470279 | -122.439587308087 | (37.7871218470279, -122.439587308087) | 13 | 6 | 1 | 29490 | 27 | |||
94004 | 143509 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003126.3661 | 2118601.4847 | 37.7974520513432 | -122.433243943801 | (37.7974520513432, -122.433243943801) | 13 | 9 | 1 | 57 | 17 | |||
94634 | 143345 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1814 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004285.9025 | 2118759.7154 | 37.7979522227532 | -122.429242932847 | (37.7979522227532, -122.429242932847) | 13 | 9 | 1 | 57 | 17 | |||
95802 | 137911 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 30 ORBEN PL | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003169.7815 | 2115326.4464 | 37.788462099298 | -122.432859626542 | (37.788462099298, -122.432859626542) | 13 | 9 | 1 | 29490 | 27 | |||
99272 | 143378 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1851 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004128.7623 | 2118691.5347 | 37.7977561189446 | -122.429781817086 | (37.7977561189446, -122.429781817086) | 13 | 9 | 1 | 57 | 17 | |||
100279 | 56932 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1911 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 18 | 3x3 | Permit Number 14176 | 6001946.3485 | 2115087.5805 | 37.787736769008 | -122.43707539686 | (37.787736769008, -122.43707539686) | 13 | 6 | 1 | 29490 | 27 | |
100833 | 66504 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2456 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | 5 | Permit Number 29667 | 6001757.7853 | 2114663.6996 | 37.786562180873 | -122.437697418913 | (37.786562180873, -122.437697418913) | 13 | 6 | 11 | 29490 | 27 | |
104849 | 143145 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2190 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6001985.4743 | 2119482.5412 | 37.7998064144784 | -122.437254839351 | (37.7998064144784, -122.437254839351) | 13 | 9 | 1 | 57 | 17 | |||
105113 | 7250 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1701 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/1990 12:00:00 AM | 12 | 4X4 | 6003025.9615 | 2114308.2396 | 37.7856582037536 | -122.433284435542 | (37.7856582037536, -122.433284435542) | 13 | 9 | 11 | 29490 | 13 | ||
105396 | 143129 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2770 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5999279.3447 | 2119102.3163 | 37.7986082139529 | -122.446591646252 | (37.7986082139529, -122.446591646252) | 13 | 9 | 1 | 57 | 17 | |||
105917 | 13104 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1530 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 90 | 3X3 | 6005037.4004 | 2119906.2866 | 37.8011429280885 | -122.426724227861 | (37.8011429280885, -122.426724227861) | 13 | 9 | 1 | 57 | 17 | ||
108065 | 143368 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1771 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004543.041 | 2118747.3779 | 37.7979329006834 | -122.428352280339 | (37.7979329006834, -122.428352280339) | 13 | 9 | 1 | 57 | 17 | |||
108721 | 56933 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1915 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 14 | 3x3 | Permit Number 14177 | 6001940.9389 | 2115134.3349 | 37.787864837109 | -122.437097461747 | (37.787864837109, -122.437097461747) | 13 | 6 | 1 | 29490 | 27 | |
109822 | 138418 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1819 STEINER ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 0ft | 6002514.5891 | 2114496.0302 | 37.7861448056429 | -122.435067070541 | (37.7861448056429, -122.435067070541) | 13 | 9 | 1 | 29490 | 27 | |||
111248 | 143361 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1892 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003980.7129 | 2118714.911 | 37.797811919551 | -122.430295777409 | (37.797811919551, -122.430295777409) | 13 | 9 | 1 | 57 | 17 | |||
111267 | 137820 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 18 ORBEN PL | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003172.6736 | 2115287.4039 | 37.7883550625506 | -122.432846830068 | (37.7883550625506, -122.432846830068) | 13 | 9 | 1 | 29490 | 27 | |||
111579 | 13197 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2114 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6002204.6803 | 2119511.1874 | 37.7998975280147 | -122.436498357806 | (37.7998975280147, -122.436498357806) | 13 | 9 | 1 | 57 | 17 | |||
111837 | 58709 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1952 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/1979 12:00:00 AM | 14 | Permit Number 17941 | 6003655.3938 | 2118679.8466 | 37.7976972096555 | -122.431418967171 | (37.7976972096555, -122.431418967171) | 13 | 9 | 1 | 57 | 17 | ||
111889 | 13171 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1940X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6003096.45 | 2119636.9817 | 37.8002935599258 | -122.433421496602 | (37.8002935599258, -122.433421496602) | 13 | 9 | 1 | 57 | 17 | |||
113929 | 21680 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1811 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003837.4434 | 2114549.281 | 37.7863660445938 | -122.430494147332 | (37.7863660445938, -122.430494147332) | 13 | 9 | 11 | 29490 | 13 | |||
114139 | 143347 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1651 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6005039.7857 | 2118817.5066 | 37.7981535519578 | -122.426638397943 | (37.7981535519578, -122.426638397943) | 13 | 9 | 1 | 57 | 17 |
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) );