trees
2,180 rows where qSpecies_id = 57 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6273 | 173900 | Private 9 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
10205 | 173902 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
11334 | 51578 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2005 12:00:00 AM | Permit Number 47872 | ||||||||||||||
14524 | 99746 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4250 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | ||||||||||||||
4457 | 27392 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2240 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007139.14869 | 2120046.64789 | 37.8016469274247 | -122.419461214785 | (37.8016469274247, -122.419461214785) | 5 | 1 | 1 | 28858 | 32 | |||
4710 | 143042 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 443 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010246.7521 | 2120590.0026 | 37.8033133880365 | -122.408745792286 | (37.8033133880365, -122.408745792286) | 3 | 1 | 10 | 308 | 23 | |||
5401 | 40626 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 721 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1999 12:00:00 AM | 5 | Permit Number 41627 | 6008236.32931 | 2114467.53897 | 37.7863898065975 | -122.415269286755 | (37.7863898065975, -122.415269286755) | 13 | 1 | 9 | 28858 | 36 | |
9252 | 73860 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1652 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6008793.24364 | 2118610.57457 | 37.7977968533 | -122.413635639483 | (37.7977968533, -122.413635639483) | 3 | 1 | 10 | 308 | 21 | |||
9311 | 71535 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1145 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6007520.46607 | 2118819.96047 | 37.7983002218264 | -122.418054666102 | (37.7983002218264, -122.418054666102) | 5 | 1 | 10 | 28858 | 32 | |||
13594 | 96006 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009630.99676 | 2116399.7599 | 37.7917735027068 | -122.410580567837 | (37.7917735027068, -122.410580567837) | 5 | 1 | 10 | 28857 | 21 |
14305 | 73447 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1045 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6007557.7828 | 2115066.68598 | 37.7879967592968 | -122.417659373585 | (37.7879967592968, -122.417659373585) | 13 | 1 | 10 | 28858 | 21 | |||
14609 | 70619 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1045 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6007580.409 | 2115068.8992 | 37.7880041094384 | -122.417581247698 | (37.7880041094384, -122.417581247698) | 13 | 1 | 10 | 28858 | 21 | |||
15273 | 249329 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 814 Post St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6008232.68347 | 2114867.71891 | 37.7874883986038 | -122.415310240102 | (37.7874883986038, -122.415310240102) | 13 | 1 | 10 | 28858 | 21 | |||
15786 | 129665 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009349.70654 | 2121620.88667 | 37.8060936540688 | -122.411922953492 | (37.8060936540688, -122.411922953492) | 3 | 1 | 10 | 308 | 23 | |||
18649 | 73588 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1145 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6007504.43189 | 2118817.2788 | 37.7982919561693 | -122.418109959117 | (37.7982919561693, -122.418109959117) | 5 | 1 | 10 | 28858 | 32 | |||
19061 | 129655 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009755.16442 | 2121852.22782 | 37.8067515980625 | -122.410536140452 | (37.8067515980625, -122.410536140452) | 3 | 1 | 10 | 308 | 23 | |||
19205 | 27390 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2240 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007140.50399 | 2120032.48345 | 37.8016081117892 | -122.419455519354 | (37.8016081117892, -122.419455519354) | 5 | 1 | 1 | 28858 | 32 | |||
21457 | 73647 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769028 | 6011581.87532 | 2119117.15178 | 37.7993439875935 | -122.404021813977 | (37.7993439875935, -122.404021813977) | 3 | 1 | 10 | 308 | 23 | |
26934 | 13003 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 363 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6010581.7377 | 2120629.8347 | 37.8034415139042 | -122.40758936746 | (37.8034415139042, -122.40758936746) | 3 | 1 | 10 | 308 | 23 | |||
28627 | 102624 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 305 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6010336.6771 | 2120942.4897 | 37.8042862667019 | -122.408459480806 | (37.8042862667019, -122.408459480806) | 3 | 1 | 10 | 308 | 23 | |||
29595 | 20276 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2291 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6009755.78997 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | 3 | 1 | 10 | 308 | 23 | |||
30959 | 129658 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009773.35506 | 2121727.83726 | 37.8064110724651 | -122.410464398813 | (37.8064110724651, -122.410464398813) | 3 | 1 | 10 | 308 | 23 | |||
31614 | 129649 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009816.83805 | 2121725.36163 | 37.8064067125673 | -122.410313742595 | (37.8064067125673, -122.410313742595) | 3 | 1 | 10 | 308 | 23 | |||
32837 | 13047 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 539 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6009759.7837 | 2120522.8139 | 37.8031016175536 | -122.410426223368 | (37.8031016175536, -122.410426223368) | 3 | 1 | 10 | 308 | 23 | |||
34155 | 129654 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009752.81774 | 2121876.72341 | 37.8068187252662 | -122.410545992499 | (37.8068187252662, -122.410545992499) | 3 | 1 | 10 | 308 | 23 | |||
35027 | 96011 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009766.64536 | 2116419.41202 | 37.7918350666884 | -122.410112610112 | (37.7918350666884, -122.410112610112) | 5 | 1 | 10 | 28857 | 21 |
39700 | 20264 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | 3 | 1 | 10 | 308 | 23 | |||
43434 | 49432 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 364@ KEARNY Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2003 12:00:00 AM | 7 | Permit Number 46371 | 6011662.83332 | 2116037.23111 | 37.7908917875712 | -122.403524862095 | (37.7908917875712, -122.403524862095) | 4 | 1 | 10 | 28854 | 6 | ||
44444 | 20277 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2291 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6009755.78997 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | 3 | 1 | 10 | 308 | 23 | |||
44808 | 20275 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2291 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6009755.78997 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | 3 | 1 | 10 | 308 | 23 | |||
45173 | 66827 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2351 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/1994 12:00:00 AM | 7 | 3x3 | Permit Number 33308 | 6009276.00847 | 2121806.91361 | 37.8066003024322 | -122.412191154694 | (37.8066003024322, -122.412191154694) | 3 | 1 | 10 | 308 | 23 | |
45856 | 37501 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 830 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1998 12:00:00 AM | 9 | Permit Number 39965 | 6009497.37561 | 2115737.1064 | 37.7899465245609 | -122.410996073526 | (37.7899465245609, -122.410996073526) | 5 | 1 | 10 | 28857 | 21 | ||
46242 | 129668 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009333.59805 | 2121722.21012 | 37.8063709591182 | -122.411985864676 | (37.8063709591182, -122.411985864676) | 3 | 1 | 10 | 308 | 23 | |||
47004 | 129621 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1513 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6007498.65921 | 2116790.15789 | 37.792725661708 | -122.417986155759 | (37.792725661708, -122.417986155759) | 5 | 1 | 10 | 28858 | 21 | |||
47447 | 129639 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1136 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007510.50379 | 2119218.83195 | 37.7993948622524 | -122.418117431574 | (37.7993948622524, -122.418117431574) | 5 | 1 | 1 | 28858 | 32 | |||
47726 | 129679 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 464 California St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6012036.63622 | 2116793.11614 | 37.79298814054 | -122.402284681698 | (37.79298814054, -122.402284681698) | 4 | 1 | 10 | 28854 | 6 | |||
48624 | 129633 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1828 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007334.41691 | 2118641.32283 | 37.7977992544837 | -122.418685778819 | (37.7977992544837, -122.418685778819) | 5 | 1 | 10 | 28858 | 32 | |||
51878 | 129613 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 711 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009198.53973 | 2115384.83404 | 37.7889625079688 | -122.412005118241 | (37.7889625079688, -122.412005118241) | 5 | 1 | 10 | 28858 | 21 | |||
52944 | 129648 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2005 12:00:00 AM | 3 | Width 3ft | 6009818.04009 | 2121706.12273 | 37.8063539547338 | -122.410308223449 | (37.8063539547338, -122.410308223449) | 3 | 1 | 10 | 308 | 23 | ||
53037 | 129619 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1220 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008570.90911 | 2116707.20552 | 37.792558183677 | -122.414270242485 | (37.792558183677, -122.414270242485) | 5 | 1 | 10 | 28857 | 21 | |||
54535 | 114470 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2351 Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6009302.49876 | 2121620.58079 | 37.8060901655936 | -122.412086302768 | (37.8060901655936, -122.412086302768) | 3 | 1 | 10 | 308 | 23 | |||
55358 | 129661 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009779.91781 | 2121666.56674 | 37.8062432068281 | -122.41043735801 | (37.8062432068281, -122.41043735801) | 3 | 1 | 10 | 308 | 23 | |||
56433 | 129622 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1513 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6007514.97588 | 2116792.81742 | 37.792733882423 | -122.417929887875 | (37.792733882423, -122.417929887875) | 5 | 1 | 10 | 28858 | 21 | |||
57516 | 129652 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009798.02273 | 2121850.39999 | 37.8067489819353 | -122.410387691144 | (37.8067489819353, -122.410387691144) | 3 | 1 | 10 | 308 | 23 | |||
58782 | 129669 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009331.79783 | 2121743.36685 | 37.8064289491925 | -122.411993590749 | (37.8064289491925, -122.411993590749) | 3 | 1 | 10 | 308 | 23 | |||
59074 | 129672 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6009324.29914 | 2121805.6091 | 37.806599430082 | -122.412023942863 | (37.806599430082, -122.412023942863) | 3 | 1 | 10 | 308 | 23 | |||
61798 | 13045 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 529 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6009805.9101 | 2120528.6658 | 37.8031202711111 | -122.410267014555 | (37.8031202711111, -122.410267014555) | 3 | 1 | 10 | 308 | 23 | |||
62054 | 9946 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2145X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007159.165551 | 2119559.7591564 | 37.8003111812757 | -122.419357387093 | (37.8003111812757, -122.419357387093) | 5 | 1 | 1 | 28858 | 32 | |||
62320 | 129640 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1201 Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007123.06001 | 2119804.16548 | 37.8009802258023 | -122.419499676077 | (37.8009802258023, -122.419499676077) | 5 | 1 | 1 | 28858 | 32 | |||
62625 | 129646 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2006 12:00:00 AM | 4 | Width 3ft | 6009824.55896 | 2121666.13191 | 37.8062445153435 | -122.410282838289 | (37.8062445153435, -122.410282838289) | 3 | 1 | 10 | 308 | 23 | ||
63465 | 96010 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767660 | 6009745.43326 | 2116416.20911 | 37.7918250833144 | -122.410185778057 | (37.7918250833144, -122.410185778057) | 5 | 1 | 10 | 28857 | 21 |
64817 | 57386 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1125 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/1976 12:00:00 AM | 9 | Permit Number 16225 | 6008086.74583 | 2116379.20728 | 37.791630372888 | -122.415922231451 | (37.791630372888, -122.415922231451) | 5 | 1 | 10 | 28858 | 21 | ||
65632 | 129635 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1181 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007311.91376 | 2119137.96682 | 37.7991616473392 | -122.418798886561 | (37.7991616473392, -122.418798886561) | 5 | 1 | 10 | 28858 | 32 | |||
67102 | 129660 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009777.61633 | 2121686.62202 | 37.8062981445983 | -122.410446739741 | (37.8062981445983, -122.410446739741) | 3 | 1 | 10 | 308 | 23 | |||
67128 | 20261 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2006 12:00:00 AM | 4 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | 3 | 1 | 10 | 308 | 23 | ||
67147 | 107462 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1629 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6008769.70277 | 2118455.29192 | 37.7973691636203 | -122.413706108551 | (37.7973691636203, -122.413706108551) | 5 | 1 | 10 | 308 | 21 | ||||
69778 | 20266 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | 3 | 1 | 10 | 308 | 23 | |||
74464 | 20263 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2005 12:00:00 AM | 3 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | 3 | 1 | 10 | 308 | 23 | ||
75292 | 20267 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | 3 | 1 | 10 | 308 | 23 | |||
78441 | 129651 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2005 12:00:00 AM | 2 | Width 3ft | 6009800.43185 | 2121827.80217 | 37.8066870690198 | -122.410377757248 | (37.8066870690198, -122.410377757248) | 3 | 1 | 10 | 308 | 23 | ||
80667 | 129624 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1914 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008681.88388 | 2119422.08299 | 37.8000188001918 | -122.414078417112 | (37.8000188001918, -122.414078417112) | 3 | 1 | 10 | 308 | 32 | |||
86637 | 129678 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 464 California St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6012048.39516 | 2116793.1627 | 37.7929889247624 | -122.402243998167 | (37.7929889247624, -122.402243998167) | 4 | 1 | 10 | 28854 | 6 | |||
87339 | 129656 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009761.43643 | 2121807.95495 | 37.8066303874512 | -122.410511306563 | (37.8066303874512, -122.410511306563) | 3 | 1 | 10 | 308 | 23 | |||
87677 | 27389 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2240 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6007143.32837 | 2120019.72314 | 37.8015732342833 | -122.419444839906 | (37.8015732342833, -122.419444839906) | 5 | 1 | 1 | 28858 | 32 | |||
89650 | 20269 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | 3 | 1 | 10 | 308 | 23 | |||
91189 | 129670 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009329.84162 | 2121764.6853 | 37.8064873745564 | -122.412001868104 | (37.8064873745564, -122.412001868104) | 3 | 1 | 10 | 308 | 23 | |||
91460 | 68920 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1652 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 5 | Permit Number 32904 | 6008796.25541 | 2118594.60343 | 37.79775316962 | -122.413624087676 | (37.79775316962, -122.413624087676) | 3 | 1 | 10 | 308 | 21 | |
93790 | 20265 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | 3 | 1 | 10 | 308 | 23 | |||
94177 | 129671 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009327.56968 | 2121786.16938 | 37.8065462369833 | -122.412011249831 | (37.8065462369833, -122.412011249831) | 3 | 1 | 10 | 308 | 23 | |||
97501 | 13032 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 463 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6010133.82601 | 2120566.41199 | 37.8032422884562 | -122.409134913081 | (37.8032422884562, -122.409134913081) | 3 | 1 | 10 | 308 | 23 | |||
98189 | 53446 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1145 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/23/1986 12:00:00 AM | 13 | Permit Number 23061 | 6007531.55063 | 2119171.09402 | 37.799264970461 | -122.418041215832 | (37.799264970461, -122.418041215832) | 5 | 1 | 10 | 28858 | 32 | |
99253 | 129664 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009352.05636 | 2121603.21217 | 37.8060452561514 | -122.411913571751 | (37.8060452561514, -122.411913571751) | 3 | 1 | 10 | 308 | 23 | |||
100302 | 13050 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 547 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6009740.1627 | 2120520.7485 | 37.8030948465246 | -122.41049397668 | (37.8030948465246, -122.41049397668) | 3 | 1 | 10 | 308 | 23 | |||
108182 | 96009 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009716.90014 | 2116412.09513 | 37.7918121879409 | -122.410284212457 | (37.7918121879409, -122.410284212457) | 5 | 1 | 10 | 28857 | 21 |
108834 | 96008 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009692.64051 | 2116408.65151 | 37.791801372693 | -122.410367907846 | (37.791801372693, -122.410367907846) | 5 | 1 | 10 | 28857 | 21 |
109986 | 20272 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2290 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2005 12:00:00 AM | 3 | 2X2 | 6009846.48172 | 2121764.71414 | 37.8065164263834 | -122.410213935106 | (37.8065164263834, -122.410213935106) | 3 | 1 | 10 | 308 | 23 | ||
110642 | 114466 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2351 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009278.4623 | 2121786.53745 | 37.8065444922964 | -122.412181221704 | (37.8065444922964, -122.412181221704) | 3 | 1 | 10 | 308 | 23 | |||
110653 | 33285 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1537 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 6 | Permit Number 37447 | 6008380.61834 | 2117789.48589 | 37.7955191682212 | -122.415005295285 | (37.7955191682212, -122.415005295285) | 5 | 1 | 10 | 28858 | 21 | |
110775 | 129642 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1161 Greenwich St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 5ft | 6007337.31848 | 2119837.29751 | 37.8010832638317 | -122.418760599735 | (37.8010832638317, -122.418760599735) | 5 | 1 | 1 | 28858 | 32 | |||
111045 | 129662 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009783.75485 | 2121643.62173 | 37.8061804206615 | -122.410422458031 | (37.8061804206615, -122.410422458031) | 3 | 1 | 10 | 308 | 23 | |||
111185 | 129657 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009762.6965 | 2121791.57324 | 37.8065854780119 | -122.410505788321 | (37.8065854780119, -122.410505788321) | 3 | 1 | 10 | 308 | 23 | |||
112379 | 129676 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 464 California St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6012082.98226 | 2116799.13729 | 37.7930072601221 | -122.402124744455 | (37.7930072601221, -122.402124744455) | 4 | 1 | 10 | 28854 | 6 | |||
113097 | 129681 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 464 California St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6012011.03614 | 2116789.35281 | 37.7929763782966 | -122.402372995143 | (37.7929763782966, -122.402372995143) | 4 | 1 | 10 | 28854 | 6 | |||
113675 | 38523 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1629 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2014 12:00:00 AM | 3 | Permit Number 773138 | 6008768.83808 | 2118471.22766 | 37.7974128706661 | -122.41371022836 | (37.7974128706661, -122.41371022836) | 5 | 1 | 10 | 308 | 21 | |
113851 | 143048 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 471 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010123.4556 | 2120570.2538 | 37.8032522561485 | -122.409171071628 | (37.8032522561485, -122.409171071628) | 3 | 1 | 10 | 308 | 23 | |||
115029 | 61248 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1993 12:00:00 AM | Permit Number 21122 | 6007711.12009364 | 2119245.98740089 | 37.7994807139026 | -122.417425152198 | (37.7994807139026, -122.417425152198) | 5 | 1 | 1 | 308 | 32 | ||
116491 | 249354 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 645 Leavenworth St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008321.82308 | 2114687.6754 | 37.7869990523159 | -122.414989085893 | (37.7869990523159, -122.414989085893) | 13 | 1 | 9 | 28858 | 36 | |||
117910 | 129620 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1513 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007483.32678 | 2116788.83942 | 37.7927211785806 | -122.418039113224 | (37.7927211785806, -122.418039113224) | 5 | 1 | 10 | 28858 | 21 | |||
119738 | 129636 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1181 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007340.70028 | 2119141.24699 | 37.7991722746363 | -122.418699507883 | (37.7991722746363, -122.418699507883) | 5 | 1 | 10 | 28858 | 32 | |||
122206 | 129663 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009355.57432 | 2121580.27361 | 37.805982469978 | -122.411899775251 | (37.805982469978, -122.411899775251) | 3 | 1 | 10 | 308 | 23 | |||
122720 | 49433 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 364@ KEARNY Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2003 12:00:00 AM | 8 | Permit Number 46371 | 6011642.68179 | 2116034.05853 | 37.7908819508039 | -122.403594362585 | (37.7908819508039, -122.403594362585) | 4 | 1 | 10 | 28854 | 6 | ||
124383 | 129647 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009820.66032 | 2121686.06094 | 37.8062990169459 | -122.410297738259 | (37.8062990169459, -122.410297738259) | 3 | 1 | 10 | 308 | 23 | |||
125787 | 96007 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009660.15049 | 2116404.46705 | 37.7917880618207 | -122.410480028126 | (37.7917880618207, -122.410480028126) | 5 | 1 | 10 | 28857 | 21 |
126589 | 249929 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 363 Filbert St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 34 | Width 0ft | 6011103.53501 | 2120007.07668 | 37.801760767194 | -122.405739765471 | (37.801760767194, -122.405739765471) | 3 | 1 | 10 | 308 | 23 | |||
127640 | 68918 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1731 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 13 | Permit Number 32899 | 6009145.56642 | 2119236.5699 | 37.799535459556 | -122.412460772349 | (37.799535459556, -122.412460772349) | 3 | 1 | 10 | 308 | 32 | |
129418 | 129674 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 464 California St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6012104.09602 | 2116801.48556 | 37.7930148863658 | -122.402051854416 | (37.7930148863658, -122.402051854416) | 4 | 1 | 10 | 28854 | 6 | |||
130951 | 129625 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 54 Glover St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 2ft | 6008038.60532 | 2118409.42437 | 37.7972021406145 | -122.416232651327 | (37.7972021406145, -122.416232651327) | 5 | 1 | 10 | 28858 | 21 | |||
131683 | 107463 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1629 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008753.83856 | 2118472.3887 | 37.7974152162793 | -122.413762212943 | (37.7974152162793, -122.413762212943) | 5 | 1 | 10 | 308 | 21 | |||||
133864 | 142939 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 308 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010769.7296 | 2118667.9444 | 37.7980651646277 | -122.406800460442 | (37.7980651646277, -122.406800460442) | 3 | 1 | 10 | 308 | 23 | |||
134760 | 37499 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 645 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 8 | Permit Number 39964 | 6010316.35975 | 2115796.38999 | 37.790155194247 | -122.408166630084 | (37.790155194247, -122.408166630084) | 5 | 1 | 10 | 28857 | 6 |
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) );