trees
1,194 rows where qSpecies_id = 50 sorted by DBH 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7834 | 229823 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 972 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6009935.37362 | 2103568.4929 | 37.7565588922846 | -122.408621852536 | (37.7565588922846, -122.408621852536) | 2 | 4 | 7 | 28859 | 19 | |||
12212 | 72455 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 548 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6010352.2868 | 2119601.9151 | 37.8006062535339 | -122.408310850279 | (37.8006062535339, -122.408310850279) | 3 | 1 | 10 | 308 | 23 | |||
19081 | 231839 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 783 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6003644.59766 | 2107707.78097 | 37.7675700520556 | -122.430672962911 | (37.7675700520556, -122.430672962911) | 7 | 9 | 5 | 28862 | 3 | |||
24108 | 226363 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 178 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6006046.41496 | 2096344.01449 | 37.7365035429963 | -122.421558204449 | (37.7365035429963, -122.421558204449) | 2 | 7 | 7 | 28859 | 2 | |||
28908 | 229866 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 116 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005094.82025 | 2098749.88858 | 37.7430558262652 | -122.425019400031 | (37.7430558262652, -122.425019400031) | 2 | 7 | 5 | 63 | 22 | |||
29462 | 226390 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 304 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006633.7821 | 2097989.5025 | 37.7410547888452 | -122.419644136891 | (37.7410547888452, -122.419644136891) | 2 | 7 | 7 | 28859 | 2 | |||
32766 | 226392 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1441 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008026.30666 | 2099772.03767 | 37.7460275775108 | -122.414955412565 | (37.7460275775108, -122.414955412565) | 2 | 7 | 7 | 28859 | 2 | |||
37213 | 229796 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3620 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005429.44821 | 2105495.57142 | 37.7615968062711 | -122.42434202887 | (37.7615968062711, -122.42434202887) | 8 | 4 | 5 | 28859 | 19 | |||
37653 | 248002 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 428 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009958.97644 | 2098527.35445 | 37.74271836107 | -122.408184696582 | (37.74271836107, -122.408184696582) | 10 | 7 | 7 | 28859 | 2 | |||
42902 | 104963 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1474X SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3z3 | Permit Number 770948 | 6008023 | 2099506 | 37.7452969115591 | -122.414948020341 | (37.7452969115591, -122.414948020341) | 2 | 7 | 7 | 28859 | 2 | ||
42972 | 226342 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 205 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006734.79318 | 2102518.91234 | 37.7534972124365 | -122.419616161673 | (37.7534972124365, -122.419616161673) | 2 | 4 | 7 | 28859 | 19 | |||
55115 | 229835 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2899 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010132.5344 | 2101618.95509 | 37.7512169355291 | -122.407802532369 | (37.7512169355291, -122.407802532369) | 2 | 4 | 7 | 28859 | 19 | |||
63833 | 190728 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6010522.48931 | 2107817.1778 | 37.7682576862591 | -122.406890823964 | (37.7682576862591, -122.406890823964) | 8 | 4 | 8 | 28853 | 19 | |||
75305 | 226455 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3330 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008017.57842 | 2104465.14642 | 37.7589133021322 | -122.4153177674 | (37.7589133021322, -122.4153177674) | 2 | 4 | 7 | 28859 | 19 | |||
76063 | 226809 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 85 Sharon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003890.70666 | 2106665.10208 | 37.7647210474575 | -122.429747326692 | (37.7647210474575, -122.429747326692) | 8 | 4 | 5 | 28862 | 3 | |||
84496 | 226411 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 950 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009265.11627 | 2098029.82714 | 37.741313383517 | -122.410548750743 | (37.741313383517, -122.410548750743) | 10 | 7 | 7 | 28859 | 2 | |||
85089 | 37988 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 613 Texas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 9 | Permit Number 40209 | 6013865.90817 | 2104201.25783 | 37.7585156794839 | -122.395072877032 | (37.7585156794839, -122.395072877032) | 10 | 3 | 8 | 28856 | 29 | |
85893 | 229808 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1801 Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009536.40285 | 2106125.11646 | 37.7635564478901 | -122.410182137596 | (37.7635564478901, -122.410182137596) | 8 | 4 | 8 | 28859 | 19 | |||
90350 | 226770 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 506 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001804.17577 | 2102825.14189 | 37.7540590746692 | -122.436689187264 | (37.7540590746692, -122.436689187264) | 2 | 4 | 5 | 28862 | 22 | |||
90647 | 229735 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1440 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009547.83815 | 2100777.83843 | 37.748874665647 | -122.409765119277 | (37.748874665647, -122.409765119277) | 2 | 4 | 7 | 28859 | 19 | |||
91105 | 226769 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 508 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001809.15664 | 2102809.6039 | 37.7540166941382 | -122.4366708501 | (37.7540166941382, -122.4366708501) | 2 | 4 | 5 | 28862 | 22 | |||
93521 | 226452 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3070 23rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008472.25902 | 2102739.35181 | 37.7542002061943 | -122.413623200976 | (37.7542002061943, -122.413623200976) | 2 | 4 | 7 | 28859 | 19 | |||
97978 | 68129 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 635 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 9 | Permit Number 31880 | 6013874.62108 | 2104078.7495 | 37.7581797826985 | -122.39503416301 | (37.7581797826985, -122.39503416301) | 10 | 3 | 8 | 28856 | 29 | |
98840 | 229870 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3952 26th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 6004170.69747 | 2100746.77802 | 37.7484865785056 | -122.42835706113 | (37.7484865785056, -122.42835706113) | 2 | 4 | 5 | 28862 | 22 | |||
99976 | 226789 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4432 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6001262.11488 | 2104680.78699 | 37.7591234062416 | -122.438696718674 | (37.7591234062416, -122.438696718674) | 2 | 4 | 5 | 28862 | 3 | |||
100983 | 226403 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 78 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008209.69188 | 2099648.73947 | 37.7456993312598 | -122.414312566376 | (37.7456993312598, -122.414312566376) | 2 | 7 | 7 | 28859 | 2 | |||
102856 | 226389 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 23 Fair Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006752.48721 | 2099574.02703 | 37.7454122236106 | -122.419346076359 | (37.7454122236106, -122.419346076359) | 2 | 7 | 7 | 28859 | 2 | |||
112490 | 226778 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3934 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003366.66584 | 2105380.90028 | 37.761165250397 | -122.431468161443 | (37.761165250397, -122.431468161443) | 15 | 4 | 5 | 28862 | 3 | |||
117745 | 229784 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1350 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010843.40414 | 2102039.00655 | 37.7524100750712 | -122.405373833155 | (37.7524100750712, -122.405373833155) | 10 | 4 | 8 | 28859 | 19 | |||
120181 | 229745 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 190 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6006000.19569 | 2099145.76871 | 37.7441939246187 | -122.421916967417 | (37.7441939246187, -122.421916967417) | 2 | 7 | 5 | 28859 | 2 | |||
123496 | 226373 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4222 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002349.44402 | 2100642.72182 | 37.7480976397016 | -122.434647475301 | (37.7480976397016, -122.434647475301) | 2 | 4 | 5 | 28862 | 22 | |||
126636 | 229890 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 67 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008246.22081 | 2099723.2099 | 37.7459058623841 | -122.414191522144 | (37.7459058623841, -122.414191522144) | 2 | 7 | 7 | 28859 | 2 | |||
139057 | 226343 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 205 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006735.41431 | 2102506.35586 | 37.7534627702098 | -122.41961312285 | (37.7534627702098, -122.41961312285) | 2 | 4 | 7 | 28859 | 19 | |||
139345 | 226820 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1891 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004617.45608 | 2097657.55415 | 37.740029548214 | -122.426592230667 | (37.740029548214, -122.426592230667) | 2 | 7 | 5 | 63 | 7 | |||
140964 | 39588 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1070 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 9 | Permit Number 40999 | 6011886.49797 | 2103421.11928 | 37.7562633193119 | -122.401863767506 | (37.7562633193119, -122.401863767506) | 10 | 3 | 8 | 28856 | 29 | |
149748 | 226387 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 28 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006154.51065 | 2098290.0214 | 37.7418529371529 | -122.421322621667 | (37.7418529371529, -122.421322621667) | 2 | 7 | 7 | 28859 | 2 | |||
156001 | 226798 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3992 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003742.96223 | 2104233.19003 | 37.7580352319537 | -122.430084836864 | (37.7580352319537, -122.430084836864) | 2 | 4 | 5 | 28862 | 3 | |||
161547 | 68190 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1625 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/1993 12:00:00 AM | 9 | Permit Number 31967 | 6012798.25639 | 2105161.94327 | 37.761094081638 | -122.398832742859 | (37.761094081638, -122.398832742859) | 10 | 3 | 8 | 28856 | 29 | ||
166899 | 229893 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 57 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008237.21282 | 2099854.86207 | 37.7462668439462 | -122.414231983545 | (37.7462668439462, -122.414231983545) | 2 | 7 | 7 | 28859 | 2 | |||
177741 | 226317 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1332 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007672.14775 | 2101889.27632 | 37.7518211306439 | -122.416329985835 | (37.7518211306439, -122.416329985835) | 2 | 4 | 7 | 28859 | 19 | |||
185042 | 32948 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 307 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | 9 | Permit Number 37265 | 6012947.03092 | 2105601.86977 | 37.7623103112918 | -122.398349060474 | (37.7623103112918, -122.398349060474) | 10 | 3 | 8 | 28856 | 29 | ||
190935 | 49831 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 547@ 20th S Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 9 | Permit Number 46614 | 6013570.32082 | 2104515.66669 | 37.7593625359769 | -122.396117192266 | (37.7593625359769, -122.396117192266) | 10 | 3 | 8 | 28856 | 29 | |
192061 | 228549 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009550.58062 | 2101412.53302 | 37.7506175499731 | -122.409800431165 | (37.7506175499731, -122.409800431165) | 2 | 4 | 7 | 28859 | 19 | |||
779 | 69766 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1725 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6014547.15395 | 2096165.56329 | 37.7364892123042 | -122.392154828809 | (37.7364892123042, -122.392154828809) | 10 | 3 | 8 | 58 | 1 | |||
5058 | 228531 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1744 Bryant St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6009451.25319 | 2106552.40785 | 37.7647249190387 | -122.410506818932 | (37.7647249190387, -122.410506818932) | 8 | 4 | 7 | 28859 | 19 | |||
10612 | 78436 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1379 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6012015.72942 | 2101977.35144 | 37.7523062600388 | -122.401315382525 | (37.7523062600388, -122.401315382525) | 10 | 3 | 8 | 28856 | 29 | |||
12120 | 70682 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 414 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6010606.08274 | 2106339.87511 | 37.7642060264098 | -122.406497569303 | (37.7642060264098, -122.406497569303) | 8 | 4 | 8 | 28859 | 19 | |||
20229 | 37987 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 613 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40209 | 6013866.01576 | 2104192.39502 | 37.7584913501141 | -122.39507188416 | (37.7584913501141, -122.39507188416) | 10 | 3 | 8 | 28856 | 29 | |
22460 | 65976 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 59 & 1/2 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | 8 | 6x6 | Permit Number 31847 | 6008257.4720065 | 2099681.55363989 | 37.7457921155362 | -122.414149670347 | (37.7457921155362, -122.414149670347) | 2 | 7 | 7 | 28859 | 2 |
24196 | 226813 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2 Belcher St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003766.50306 | 2108228.71833 | 37.7690073251557 | -122.430288478441 | (37.7690073251557, -122.430288478441) | 7 | 9 | 5 | 28862 | 3 | |||
24742 | 37969 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 601 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40199 | 6013584.10507 | 2104296.87899 | 37.7587625595637 | -122.396054186654 | (37.7587625595637, -122.396054186654) | 10 | 3 | 8 | 28856 | 29 | |
24898 | 226454 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3273 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006579.31902 | 2103170.31631 | 37.7552770588978 | -122.420200053701 | (37.7552770588978, -122.420200053701) | 2 | 4 | 7 | 28859 | 19 | |||
27538 | 226448 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3070 23rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008539 | 2102800 | 37.7543704799177 | -122.41339668212 | (37.7543704799177, -122.41339668212) | 2 | 4 | 7 | 28859 | 19 | |||
28755 | 226347 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3175 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008486.7284 | 2101525.46437 | 37.7508679571961 | -122.413487316996 | (37.7508679571961, -122.413487316996) | 2 | 4 | 7 | 28859 | 19 | |||
28887 | 37673 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3330 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | 8 | 0x0 | Permit Number 40071 | 6008076 | 2104474 | 37.758940895326 | -122.415116344354 | (37.758940895326, -122.415116344354) | 2 | 4 | 7 | 28859 | 19 |
29482 | 104712 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 303 ARKANSAS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x4 | 6012983 | 2105615 | 37.7623483675995 | -122.39822557732 | (37.7623483675995, -122.39822557732) | 10 | 3 | 8 | 28856 | 29 | |||
29685 | 190682 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 546 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010644.58891 | 2105668.45784 | 37.7623646204591 | -122.406317076288 | (37.7623646204591, -122.406317076288) | 8 | 4 | 8 | 28859 | 19 | |||
34325 | 248003 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 428 Franconia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009956.29023 | 2098510.13636 | 37.7426709335279 | -122.408192770677 | (37.7426709335279, -122.408192770677) | 10 | 7 | 7 | 28859 | 2 | |||
39052 | 229883 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3784 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008413.69404 | 2097282.59684 | 37.7392138829104 | -122.413439846296 | (37.7392138829104, -122.413439846296) | 2 | 7 | 7 | 28859 | 2 | |||
39351 | 226812 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2 Belcher St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 1ft | 6003760.63198 | 2108231.56549 | 37.7690148102126 | -122.430308989291 | (37.7690148102126, -122.430308989291) | 7 | 9 | 5 | 28862 | 3 | |||
40005 | 229894 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1435 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008020.95699 | 2099824.31502 | 37.7461708188376 | -122.414977610555 | (37.7461708188376, -122.414977610555) | 2 | 7 | 7 | 28859 | 2 | |||
41705 | 229798 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 69 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006019.29949 | 2105109.06322 | 37.7605688353024 | -122.422274509073 | (37.7605688353024, -122.422274509073) | 2 | 4 | 5 | 28859 | 19 | |||
43619 | 229810 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1801 Bryant St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009529.11729 | 2106277.27866 | 37.7639738421376 | -122.4102180799 | (37.7639738421376, -122.4102180799) | 8 | 4 | 8 | 28859 | 19 | |||
43994 | 229790 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1471 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007575.95086 | 2107340.46198 | 37.7667834204423 | -122.417048857113 | (37.7667834204423, -122.417048857113) | 8 | 4 | 7 | 28853 | 19 | |||
47184 | 226313 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2479 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008246.47754 | 2104016.96539 | 37.7576955616045 | -122.414494411095 | (37.7576955616045, -122.414494411095) | 2 | 4 | 7 | 28859 | 19 | |||
48985 | 100215 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 59 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 7x6 | 6008249 | 2099678 | 37.7457818821655 | -122.414178714053 | (37.7457818821655, -122.414178714053) | 2 | 7 | 7 | 28859 | 2 | |||
50870 | 129100 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 701 Buchanan St | 3 | : | Tree | Private 2 | 8 | Width 6ft | 6004473.20652 | 2110925.86056 | 37.7764530246232 | -122.428036263087 | (37.7764530246232, -122.428036263087) | 7 | 9 | 11 | 28852 | 10 | |||
53104 | 229794 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 270 14th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6006938.57132 | 2107935.81183 | 37.7683822351787 | -122.419295689168 | (37.7683822351787, -122.419295689168) | 8 | 4 | 7 | 28853 | 19 | |||
55153 | 229747 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 84 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005427.81149 | 2099645.37238 | 37.7455334252207 | -122.423931669125 | (37.7455334252207, -122.423931669125) | 2 | 7 | 5 | 28859 | 22 | |||
55488 | 220057 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 938 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007984.69118 | 2102236.05472 | 37.752790875909 | -122.415273710521 | (37.752790875909, -122.415273710521) | 2 | 4 | 7 | 28859 | 19 | |||
58645 | 226791 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 43 Yukon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000246.5901 | 2104825.81574 | 37.7594637951501 | -122.442219288501 | (37.7594637951501, -122.442219288501) | 2 | 4 | 5 | 28862 | 3 | |||
60065 | 17889 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2231 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2000 12:00:00 AM | 8 | 3x3 | 6003230.4792 | 2115158.6176 | 37.7880047264698 | -122.432637629177 | (37.7880047264698, -122.432637629177) | 13 | 9 | 11 | 29490 | 27 | ||
64607 | 229834 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2899 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010114.09042 | 2101618.66364 | 37.7512151027139 | -122.407866293408 | (37.7512151027139, -122.407866293408) | 2 | 4 | 7 | 28859 | 19 | |||
64830 | 40096 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 359 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2001 12:00:00 AM | 8 | Permit Number 44400 | 6014088.36289 | 2105304.3939 | 37.7615570193592 | -122.394380761457 | (37.7615570193592, -122.394380761457) | 10 | 3 | 8 | 28856 | 29 | ||
71137 | 37945 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 829 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40186 | 6012472.75193 | 2104081.82753 | 37.7581101796629 | -122.399882680666 | (37.7581101796629, -122.399882680666) | 10 | 3 | 8 | 28856 | 29 | |
74132 | 229869 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 314 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003810.99153 | 2099557.89821 | 37.7452018299076 | -122.42951614338 | (37.7452018299076, -122.42951614338) | 2 | 7 | 5 | 63 | 22 | |||
76750 | 226348 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3171 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008541.46923 | 2101528.90291 | 37.7508804721644 | -122.41329826061 | (37.7508804721644, -122.41329826061) | 2 | 4 | 7 | 28859 | 19 | |||
76930 | 226311 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2070 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008053.75125 | 2106490.49002 | 37.7644764615472 | -122.415336042545 | (37.7644764615472, -122.415336042545) | 8 | 4 | 7 | 28859 | 19 | |||
77562 | 226327 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007824.63975 | 2105811.28938 | 37.7625986546389 | -122.416080374504 | (37.7625986546389, -122.416080374504) | 8 | 4 | 7 | 28859 | 19 | |||
77899 | 229824 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1306 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010048.45335 | 2101561.19156 | 37.7510536222315 | -122.408089221836 | (37.7510536222315, -122.408089221836) | 2 | 4 | 7 | 28859 | 19 | |||
78886 | 229832 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1216 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010283.83962 | 2102006.15901 | 37.7522885811545 | -122.407306593143 | (37.7522885811545, -122.407306593143) | 2 | 4 | 7 | 28859 | 19 | |||
80265 | 226446 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3102 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008932.04499 | 2101596.23583 | 37.7510872739702 | -122.411952365814 | (37.7510872739702, -122.411952365814) | 2 | 4 | 7 | 28859 | 19 | |||
84269 | 228528 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1718 Bryant St | 1 | : | Tree | Private 2 | 8 | Width 4ft | 6009443.5955 | 2106700.35684 | 37.7651307237316 | -122.410543753197 | (37.7651307237316, -122.410543753197) | 8 | 4 | 7 | 28859 | 19 | |||
89588 | 190720 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 315 Mississippi St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6014070.97859 | 2105596.22306 | 37.7623573521408 | -122.394461321843 | (37.7623573521408, -122.394461321843) | 10 | 3 | 8 | 28856 | 29 | |||
100542 | 226332 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 375 Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006554.33185 | 2103938.10379 | 37.757383817915 | -122.420340959477 | (37.757383817915, -122.420340959477) | 2 | 4 | 7 | 28859 | 19 | |||
101745 | 129099 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 240 Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002192.18689 | 2118975.47765 | 37.7984258993922 | -122.436503225465 | (37.7984258993922, -122.436503225465) | 13 | 9 | 1 | 57 | 17 | |||
103087 | 37937 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1833 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40182 | 6012230.73908 | 2105130.49486 | 37.7609760932842 | -122.400793343137 | (37.7609760932842, -122.400793343137) | 10 | 3 | 8 | 28856 | 29 | |
111480 | 226457 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3330 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008057.36787 | 2104469.97829 | 37.758928805544 | -122.415180498503 | (37.758928805544, -122.415180498503) | 2 | 4 | 7 | 28859 | 19 | |||
111960 | 68104 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 77 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | 8 | 5x7 | Permit Number 31850 | 6008263.32103821 | 2099576.36139011 | 37.7455036095439 | -122.414122004435 | (37.7455036095439, -122.414122004435) | 2 | 7 | 7 | 28859 | 2 |
113967 | 32967 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 571 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 8 | Permit Number 37282 | 6014131.46964 | 2104484.11535 | 37.7593071089655 | -122.394174242052 | (37.7593071089655, -122.394174242052) | 10 | 3 | 8 | 28856 | 29 | |
118059 | 229851 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3476 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005224.27496 | 2103144.25068 | 37.7551290439715 | -122.424884349738 | (37.7551290439715, -122.424884349738) | 2 | 4 | 5 | 28859 | 19 | |||
118855 | 229817 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 990 Treat Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008585.08431 | 2102813.4393 | 37.7544099685703 | -122.413238260532 | (37.7544099685703, -122.413238260532) | 2 | 4 | 7 | 28859 | 19 | |||
121342 | 226766 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 84 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005428.90079 | 2099643.28917 | 37.7455277666988 | -122.423927754381 | (37.7455277666988, -122.423927754381) | 2 | 7 | 5 | 28859 | 22 | |||
123784 | 226378 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 511 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008209.35637 | 2096429.78748 | 37.7368607798011 | -122.414086039755 | (37.7368607798011, -122.414086039755) | 2 | 7 | 7 | 28859 | 2 | |||
125171 | 228544 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1457 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009585.79398 | 2100740.24888 | 37.7487735800335 | -122.409631214704 | (37.7487735800335, -122.409631214704) | 2 | 4 | 7 | 28859 | 19 | |||
129802 | 226397 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1490 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008007.72496 | 2099487.35787 | 37.745244866072 | -122.414999519809 | (37.745244866072, -122.414999519809) | 2 | 7 | 7 | 28859 | 2 | |||
131668 | 101142 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 450 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6x5 | 6013202.87541 | 2105008.80467 | 37.7606961334358 | -122.397422590588 | (37.7606961334358, -122.397422590588) | 10 | 3 | 8 | 28856 | 29 | |||
133185 | 229749 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3420 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006865.44243 | 2100893.16424 | 37.7490406373221 | -122.419049042884 | (37.7490406373221, -122.419049042884) | 2 | 4 | 7 | 28859 | 19 | |||
135298 | 226383 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 45 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007419.20582 | 2097997.75063 | 37.7411216480553 | -122.416929004483 | (37.7411216480553, -122.416929004483) | 2 | 7 | 7 | 28859 | 2 | |||
138806 | 226450 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3070 23rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008539 | 2102800 | 37.7543704799177 | -122.41339668212 | (37.7543704799177, -122.41339668212) | 2 | 4 | 7 | 28859 | 19 |
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) );