trees

136 rows where qSpecies_id = 225

✎ View and edit SQL

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)
2358 35806 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 48 Sycamore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/22/1998 12:00:00 AM     Permit Number 39050 6006557.62447631 2105882.41132606 37.7627226190877 -122.420467579489 (37.7627226190877, -122.420467579489) 8 4 7 28859 19
2928 261272 DPW Maintained 1 Photinia fraseri :: Photinia Tree 225 500 Ivy St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/12/1995 12:00:00 AM   Width 0ft   6004944 2111107 37.7769770135596 -122.426420554341 (37.7769770135596, -122.426420554341) 7 9 11 28852 10
4727 51621 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 465 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/2005 12:00:00 AM     Permit Number 47916 6010931.94121292 2112045.86318657 37.7798915829784 -122.40577246257 (37.7798915829784, -122.40577246257) 14 2 9 28853 34
5957 261280 DPW Maintained 1 Photinia fraseri :: Photinia Tree 225 500 Ivy St 11 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6004944 2111107 37.7769770135596 -122.426420554341 (37.7769770135596, -122.426420554341) 7 9 11 28852 10
7886 261276 DPW Maintained 1 Photinia fraseri :: Photinia Tree 225 500 Ivy St 7 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6004944 2111107 37.7769770135596 -122.426420554341 (37.7769770135596, -122.426420554341) 7 9 11 28852 10
8579 261278 DPW Maintained 1 Photinia fraseri :: Photinia Tree 225 500 Ivy St 9 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6004944 2111107 37.7769770135596 -122.426420554341 (37.7769770135596, -122.426420554341) 7 9 11 28852 10
9596 34341 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 1256 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/17/1999 12:00:00 AM     Permit Number 38098 6010025.23435755 2101885.23232138 37.7519420662896 -122.408192367354 (37.7519420662896, -122.408192367354) 2 4 7 28859 19
13731 261284 DPW Maintained 1 Photinia fraseri :: Photinia Tree 225 500 Ivy St 15 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6004944 2111107 37.7769770135596 -122.426420554341 (37.7769770135596, -122.426420554341) 7 9 11 28852 10
14748 261274 DPW Maintained 1 Photinia fraseri :: Photinia Tree 225 500 Ivy St 5 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6004944 2111107 37.7769770135596 -122.426420554341 (37.7769770135596, -122.426420554341) 7 9 11 28852 10
14779 31332 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 500 Ivy St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM     Permit Number 34950 6004711 2111132 37.7770324835269 -122.427228354699 (37.7770324835269, -122.427228354699) 7 9 11 28852 10
15011 261290 DPW Maintained 1 Photinia fraseri :: Photinia Tree 225 500 Ivy St 21 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6004944 2111107 37.7769770135596 -122.426420554341 (37.7769770135596, -122.426420554341) 7 9 11 28852 10
17494 261285 DPW Maintained 1 Photinia fraseri :: Photinia Tree 225 500 Ivy St 16 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6004944 2111107 37.7769770135596 -122.426420554341 (37.7769770135596, -122.426420554341) 7 9 11 28852 10
18255 64981 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 18 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/24/1989 12:00:00 AM     Permit Number 26019 6005742.91166727 2099374.35600444 37.7448070600877 -122.422822842916 (37.7448070600877, -122.422822842916) 2 7 5 28859 22
18573 261282 DPW Maintained 1 Photinia fraseri :: Photinia Tree 225 500 Ivy St 13 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6004944 2111107 37.7769770135596 -122.426420554341 (37.7769770135596, -122.426420554341) 7 9 11 28852 10
23119 32679 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 899 Howard St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37098 6011223.96618851 2112626.31921579 37.7815017061756 -122.404803090396 (37.7815017061756, -122.404803090396) 6 2 9 28853 34
24667 65797 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 2227 19th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/1990 12:00:00 AM     Permit Number 28765 5990377.34556351 2100223.38018411 37.7462593077225 -122.476015504555 (37.7462593077225, -122.476015504555) 1 8 3 29491 35
25521 31566 DPW Maintained 1 Photinia fraseri :: Photinia Tree 225 308 Ewing Ter 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM 5   Permit Number 35106 5998541.7634509 2112162.0975269 37.779510049305 -122.44864377763 (37.779510049305, -122.44864377763) 15 6 2 54 16
27190 30934 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 910 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM     Permit Number 34747 5995945.63998 2089982.79066164 37.7184624266242 -122.456020912886 (37.7184624266242, -122.456020912886) 9 8 6 28861 24
29299 32677 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 899 Howard St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37098 6011223.96618851 2112626.31921579 37.7815017061756 -122.404803090396 (37.7815017061756, -122.404803090396) 6 2 9 28853 34
32509 30922 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 150 Holloway Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM     Permit Number 34737 5996375.06568666 2091233.55028931 37.7219213567264 -122.454626885388 (37.7219213567264, -122.454626885388) 9 8 4 28861 24
32843 60341 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 262 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1982 12:00:00 AM     Permit Number 19917 6002689.36416873 2104369.44645682 37.7583496312506 -122.433738362773 (37.7583496312506, -122.433738362773) 2 4 5 28862 3
40785 68008 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 525 Victoria St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/20/1993 12:00:00 AM     Permit Number 31733 5993230.57991473 2090673.1721909 37.7202018358304 -122.465455798615 (37.7202018358304, -122.465455798615) 9 8 6 64 24
42316 31903 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 969 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1995 12:00:00 AM     Permit Number 35328 6008029.13454048 2109879.85819982 37.7737814887342 -122.415661184007 (37.7737814887342, -122.415661184007) 8 2 9 28853 34
43402 67351 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 713 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1992 12:00:00 AM     Permit Number 30838 6009876.15204434 2104954.24625098 37.7603605418838 -122.408924431594 (37.7603605418838, -122.408924431594) 2 4 8 28859 19
45965 33153 DPW Maintained 1 Photinia fraseri :: Photinia Tree 225 2346 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM 0   Permit Number 37376 5986428.80403159 2099276.07273769 37.7434285126993 -122.48959924593 (37.7434285126993, -122.48959924593) 1 8 3 29491 35
46445 31569 DPW Maintained 1 Photinia fraseri :: Photinia Tree 225 338 Ewing Ter 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM 1   Permit Number 35109 5998637.37673043 2112175.28260536 37.7795517188659 -122.448313961687 (37.7795517188659, -122.448313961687) 15 6 2 54 16
48946 32681 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 899 Howard St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37098 6011223.96618851 2112626.31921579 37.7815017061756 -122.404803090396 (37.7815017061756, -122.404803090396) 6 2 9 28853 34
49784 60336 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 127 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1982 12:00:00 AM     Permit Number 19910 6002696.65080331 2105157.46934555 37.7605137659051 -122.433769484484 (37.7605137659051, -122.433769484484) 2 4 5 28862 3
51493 32503 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 292 Crescent Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/15/1996 12:00:00 AM     Permit Number 37007 6006814.5953718 2095750.97368138 37.7349184687173 -122.418860225731 (37.7349184687173, -122.418860225731) 2 7 7 28859 2
51688 31315 DPW Maintained 1 Photinia fraseri :: Photinia Tree 225 500 Ivy St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM 6 2.5x2 Permit Number 34950 6004711 2111132 37.7770324835269 -122.427228354699 (37.7770324835269, -122.427228354699) 7 9 11 28852 10
52960 34395 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 131 Moffitt St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38142 6002633.1447609 2096796.28026011 37.7375523083094 -122.433391625623 (37.7375523083094, -122.433391625623) 2 7 5 63 7
56566 30921 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 150 Holloway Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM     Permit Number 34737 5996375.06568666 2091233.55028931 37.7219213567264 -122.454626885388 (37.7219213567264, -122.454626885388) 9 8 4 28861 24
62132 31329 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 500 Ivy St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM     Permit Number 34950 6004943.48429565 2111113.32646023 37.7769943553193 -122.426422788886 (37.7769943553193, -122.426422788886) 7 9 11 28852 10
62470 64956 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 90 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/03/1989 12:00:00 AM     Permit Number 25987 6005330.51370427 2099351.30383605 37.744720486614 -122.424247199326 (37.744720486614, -122.424247199326) 2 7 5 28859 22
63097 31170 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 701 Randolph St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34870 5992182.10994821 2088503.70058995 37.7141844683459 -122.468922182021 (37.7141844683459, -122.468922182021) 9 8 6 64 24
63796 31884 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 142 10th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1995 12:00:00 AM     Permit Number 35320 6008136.56903408 2110210.75030883 37.7746960787711 -122.415312978758 (37.7746960787711, -122.415312978758) 8 2 9 28853 34
65369 31379 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 1200 Ulloa St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1995 12:00:00 AM     Permit Number 34979 5992487.7099523 2098471.6596412 37.7415716707885 -122.468590752076 (37.7415716707885, -122.468590752076) 1 8 4 29491 40
67672 31323 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 500 Ivy St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM     Permit Number 34950 6004943.48429565 2111113.32646023 37.7769943553193 -122.426422788886 (37.7769943553193, -122.426422788886) 7 9 11 28852 10
71667 66636 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 970 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/15/1991 12:00:00 AM     Permit Number 29847 6010191.25055657 2103570.92825011 37.7565799066669 -122.407737106169 (37.7565799066669, -122.407737106169) 2 4 7 28859 19
73222 30923 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 150 Holloway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM     Permit Number 34737 5996375.06568666 2091233.55028931 37.7219213567264 -122.454626885388 (37.7219213567264, -122.454626885388) 9 8 4 28861 24
79493 31567 DPW Maintained 1 Photinia fraseri :: Photinia Tree 225 320 Ewing Ter 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM 6   Permit Number 35107 5998580.00875789 2112167.37155762 37.779526717238 -122.448511851314 (37.779526717238, -122.448511851314) 15 6 2 54 16
82902 65397 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 129 Hancock St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/25/1989 12:00:00 AM     Permit Number 769855 6003450.9408687 2105044.43183692 37.7602461647902 -122.43115267366 (37.7602461647902, -122.43115267366) 2 4 5 28862 3
83327 31327 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 500 Ivy St 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM     Permit Number 34950 6004943.48429565 2111113.32646023 37.7769943553193 -122.426422788886 (37.7769943553193, -122.426422788886) 7 9 11 28852 10
85478 31324 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 500 Ivy St 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM     Permit Number 34950 6004943.48429565 2111113.32646023 37.7769943553193 -122.426422788886 (37.7769943553193, -122.426422788886) 7 9 11 28852 10
88186 31368 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 300 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1995 12:00:00 AM 3 3x3 Permit Number 34972 5992325.0295125 2099143.1296763 37.7434059578849 -122.46920210066 (37.7434059578849, -122.46920210066) 1 8 4 29491 40
88752 31380 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 1200 Ulloa St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1995 12:00:00 AM     Permit Number 34979 5992487.7099523 2098471.6596412 37.7415716707885 -122.468590752076 (37.7415716707885, -122.468590752076) 1 8 4 29491 40
89995 64935 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 760 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1989 12:00:00 AM     Permit Number 25963 6005620.53901807 2098700.72854642 37.7429505266072 -122.42319811087 (37.7429505266072, -122.42319811087) 2 7 5 28859 22
91733 32803 DPW Maintained 1 Photinia fraseri :: Photinia Tree 225 1671 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1996 12:00:00 AM 8   Permit Number 37164 5999872.45822482 2110179.18202551 37.7741414695256 -122.443897845399 (37.7741414695256, -122.443897845399) 15 5 11 29492 16
91740 31892 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 999 Natoma St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1995 12:00:00 AM     Permit Number 35322 6007970.79373767 2109754.69864739 37.7734345505501 -122.415854130267 (37.7734345505501, -122.415854130267) 8 2 9 28853 34
91867 31885 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 142 10th St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1995 12:00:00 AM     Permit Number 35320 6008136.56903408 2110210.75030883 37.7746960787711 -122.415312978758 (37.7746960787711, -122.415312978758) 8 2 9 28853 34
91910 31883 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 142 10th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1995 12:00:00 AM     Permit Number 35320 6008136.56903408 2110210.75030883 37.7746960787711 -122.415312978758 (37.7746960787711, -122.415312978758) 8 2 9 28853 34
93084 60335 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 4075 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/03/1982 12:00:00 AM     Permit Number 20006 6002530.02077701 2104700.74933312 37.7592502662204 -122.434313127594 (37.7592502662204, -122.434313127594) 2 4 5 28862 3
102988 34046 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 298 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM 3   Permit Number 37957 6008878.33665025 2106854.71470607 37.7655228486031 -122.41250976517 (37.7655228486031, -122.41250976517) 8 4 7 28853 19
106897 31568 DPW Maintained 1 Photinia fraseri :: Photinia Tree 225 332 Ewing Ter 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM 0   Permit Number 35108 5998618.25406489 2112172.64558834 37.7795433850234 -122.448379924939 (37.7795433850234, -122.448379924939) 15 6 2 54 16
107581 31333 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 500 Ivy St 15 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM     Permit Number 34950 6004943.48429565 2111113.32646023 37.7769943553193 -122.426422788886 (37.7769943553193, -122.426422788886) 7 9 11 28852 10
108372 31322 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 500 Ivy St 16 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM   2.5x3 Permit Number 34950 6004943.48429565 2111113.32646023 37.7769943553193 -122.426422788886 (37.7769943553193, -122.426422788886) 7 9 11 28852 10
110044 30912 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 180 Granada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM     Permit Number 34733 5995664.56548736 2091086.14312969 37.7214758341973 -122.457072231663 (37.7214758341973, -122.457072231663) 9 8 6 28861 24
110255 56609 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 109 Chaves Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM     Permit Number 31087 5996782.90480666 2098550.32582843 37.7420348499326 -122.453745188424 (37.7420348499326, -122.453745188424) 9 7 4 59 40
110628 38437 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 725 Florida St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/1998 12:00:00 AM     Permit Number 40463 6009320.84267661 2104866.82634812 37.7600893851951 -122.410838821684 (37.7600893851951, -122.410838821684) 2 4 7 28859 19
113183 32685 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 899 Howard St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37098 6011223.96618851 2112626.31921579 37.7815017061756 -122.404803090396 (37.7815017061756, -122.404803090396) 6 2 9 28853 34
113615 66645 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 2620 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/05/1991 12:00:00 AM 10 3x3 Permit Number 29856 6010352.98815253 2104015.30815084 37.7578091273277 -122.407209080973 (37.7578091273277, -122.407209080973) 10 4 7 28859 19
113824 34297 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 2880 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38086 6010150.01675052 2101665.50876097 37.7513457403032 -122.40774535844 (37.7513457403032, -122.40774535844) 2 4 7 28859 19
114318 68005 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 501 Victoria St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1993 12:00:00 AM     Permit Number 31730 5993229.33606132 2090506.48528425 37.7197440821869 -122.46544799569 (37.7197440821869, -122.46544799569) 9 8 6 64 24
114917 38436 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 725 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/11/2000 12:00:00 AM     Permit Number 43557 6009320.84267661 2104866.82634812 37.7600893851951 -122.410838821684 (37.7600893851951, -122.410838821684) 2 4 7 28859 19
116150 63697 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 1719 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/09/1987 12:00:00 AM     Permit Number 24355 5993080.74651115 2103769.27356941 37.7561518025238 -122.466925288995 (37.7561518025238, -122.466925288995) 1 8 4 56 12
121588 60345 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 252 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1982 12:00:00 AM     Permit Number 19923 6002686.26660489 2104425.50101172 37.7585033678265 -122.433753081837 (37.7585033678265, -122.433753081837) 2 4 5 28862 3
123407 105266 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 737 GONZALEZ DR 3 Sidewalk: Curb side : Yard Tree Private 2     3     5988857.6 2089713.7 37.7173141872637 -122.480501360019 (37.7173141872637, -122.480501360019) 1 8 4 64 14
123992 25511 DPW Maintained 1 Photinia fraseri :: Photinia Tree 225 2340 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   08/02/1996 12:00:00 AM 6 3X3   6010444.87816 2095088.76125 37.7333039164127 -122.406262360289 (37.7333039164127, -122.406262360289) 10 3 7 309 28
124559 31386 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 1200 Ulloa St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1995 12:00:00 AM     Permit Number 34979 5992487.7099523 2098471.6596412 37.7415716707885 -122.468590752076 (37.7415716707885, -122.468590752076) 1 8 4 29491 40
125418 32683 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 899 Howard St 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37098 6011223.96618851 2112626.31921579 37.7815017061756 -122.404803090396 (37.7815017061756, -122.404803090396) 6 2 9 28853 34
126814 31882 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 142 10th St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1995 12:00:00 AM       6008136.56903408 2110210.75030883 37.7746960787711 -122.415312978758 (37.7746960787711, -122.415312978758) 8 2 9 28853 34
128304 255589 DPW Maintained 1 Photinia fraseri :: Photinia Tree 225 185 San Carlos St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006715 2105087 37.7605474726944 -122.419866827586 (37.7605474726944, -122.419866827586) 2 4 7 28859 19
129669 234424 DPW Maintained 1 Photinia fraseri :: Photinia Tree 225 360 Church St 1 : Tree Private 2     6 Width 3ft Permit Number 780144 6004154.11162 2106813.10444 37.7651423384845 -122.428846830126 (37.7651423384845, -122.428846830126) 8 4 5 28862 3
133040 31314 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 500 Ivy St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM     Permit Number 34950 6004943.48429565 2111113.32646023 37.7769943553193 -122.426422788886 (37.7769943553193, -122.426422788886) 7 9 11 28852 10
133043 60339 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 217 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1982 12:00:00 AM     Permit Number 19913 6002727.03615793 2104630.16660903 37.7590676437119 -122.433626709537 (37.7590676437119, -122.433626709537) 2 4 5 28862 3
133089 31381 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 1200 Ulloa St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1995 12:00:00 AM     Permit Number 34979 5992487.7099523 2098471.6596412 37.7415716707885 -122.468590752076 (37.7415716707885, -122.468590752076) 1 8 4 29491 40
133783 31378 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 1200 Ulloa St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1995 12:00:00 AM     Permit Number 34979 5992487.7099523 2098471.6596412 37.7415716707885 -122.468590752076 (37.7415716707885, -122.468590752076) 1 8 4 29491 40
134987 32680 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 899 Howard St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37098 6011223.96618851 2112626.31921579 37.7815017061756 -122.404803090396 (37.7815017061756, -122.404803090396) 6 2 9 28853 34
135822 58784 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 1494 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1989 12:00:00 AM     Permit Number 25965 6005850.84405756 2100254.33506162 37.747229371611 -122.422512149556 (37.747229371611, -122.422512149556) 2 7 5 28859 22
136005 123454 DPW Maintained 1 Photinia fraseri :: Photinia Tree 225 713 02nd Ave 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft Permit Number 779827 5995320.73299 2110668.0352 37.7752230435543 -122.459678373092 (37.7752230435543, -122.459678373092) 11 6 2 54 11
136274 68266 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 400 Holyoke St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32072 6009713.40649943 2092546.71615196 37.7262830554111 -122.408612007775 (37.7262830554111, -122.408612007775) 10 3 7 309 28
138321 68007 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 521 Victoria St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/20/1993 12:00:00 AM     Permit Number 31732 5993230.37260583 2090645.39103979 37.7201255435589 -122.465454498121 (37.7201255435589, -122.465454498121) 9 8 6 64 24
138608 31370 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 300 Taraval St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1995 12:00:00 AM 4 3x3 Permit Number 34972 5992325.0295125 2099143.1296763 37.7434059578849 -122.46920210066 (37.7434059578849, -122.46920210066) 1 8 4 29491 40
139814 68361 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 600 Bacon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/29/1993 12:00:00 AM     Permit Number 32182 6009717.95437721 2092589.77747592 37.7264015474603 -122.408599322266 (37.7264015474603, -122.408599322266) 10 3 7 309 28
141529 66637 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 964 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/15/1991 12:00:00 AM     Permit Number 29848 6010189.39400584 2103604.41953391 37.7566717623093 -122.407745888263 (37.7566717623093, -122.407745888263) 2 4 7 28859 19
142341 67667 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 101 Thornton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1992 12:00:00 AM     Permit Number 31269 6014176.68683306 2094076.04922403 37.730731257346 -122.393289526309 (37.730731257346, -122.393289526309) 10 3 8 58 1
143591 60344 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 231-235 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1982 12:00:00 AM     Permit Number 19921 6002731.37274881 2104551.69020493 37.7588524124281 -122.433606103067 (37.7588524124281, -122.433606103067) 2 4 5 28862 3
143753 31316 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 500 Ivy St 13 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM   2.5x2 Permit Number 34950 6004943.48429565 2111113.32646023 37.7769943553193 -122.426422788886 (37.7769943553193, -122.426422788886) 7 9 11 28852 10
145059 66072 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 538 Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/06/1990 12:00:00 AM     Permit Number 29113 6014071.12882517 2104592.06579407 37.7596001633674 -122.394390489971 (37.7596001633674, -122.394390489971) 10 3 8 28856 29
145686 66771 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 36 Sycamore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/12/1991 12:00:00 AM     Permit Number 30030 6006613.63944033 2105885.51922776 37.762734309167 -122.42027406386 (37.762734309167, -122.42027406386) 8 4 7 28859 19
146959 66769 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 50 Sycamore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/12/1991 12:00:00 AM     Permit Number 30028 6006548.28864897 2105881.89334244 37.7627206707103 -122.420499832088 (37.7627206707103, -122.420499832088) 8 4 7 28859 19
147430 68265 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 389 Holyoke St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32071 6009742.13570335 2092630.55377665 37.7265148648795 -122.408518603248 (37.7265148648795, -122.408518603248) 10 3 7 309 28
147786 64936 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 647 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1989 12:00:00 AM     Permit Number 25964 6005958.80955295 2099650.25200698 37.7455767871938 -122.422095904179 (37.7455767871938, -122.422095904179) 2 7 5 28859 2
148328 60342 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 271 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1982 12:00:00 AM     Permit Number 19918 6002743.76300823 2104327.47191197 37.7582374658514 -122.433547228098 (37.7582374658514, -122.433547228098) 2 4 5 28862 3
151652 32502 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 292 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/15/1996 12:00:00 AM     Permit Number 37007 6006814.5953718 2095750.97368138 37.7349184687173 -122.418860225731 (37.7349184687173, -122.418860225731) 2 7 7 28859 2
151886 31369 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 300 Taraval St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1995 12:00:00 AM 4 3x3 Permit Number 34972 5992325.0295125 2099143.1296763 37.7434059578849 -122.46920210066 (37.7434059578849, -122.46920210066) 1 8 4 29491 40
153374 31382 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 1200 Ulloa St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1995 12:00:00 AM     Permit Number 34979 5992487.7099523 2098471.6596412 37.7415716707885 -122.468590752076 (37.7415716707885, -122.468590752076) 1 8 4 29491 40
154215 34296 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 2880 25th St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38086 6010150.01675052 2101665.50876097 37.7513457403032 -122.40774535844 (37.7513457403032, -122.40774535844) 2 4 7 28859 19
154957 33312 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 1760 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1996 12:00:00 AM     Permit Number 37459 6004517.82386146 2119140.37015121 37.7990105296091 -122.428467564949 (37.7990105296091, -122.428467564949) 13 9 1 57 17
155094 60340 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 234-238 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1982 12:00:00 AM     Permit Number 19915 6002680.69098813 2104526.39924408 37.7587800937402 -122.433779576314 (37.7587800937402, -122.433779576314) 2 4 5 28862 3

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);