88 rows where Police Districts = 4 and qSpecies_id = 5 sorted by PlantDate

View and edit SQL

Police Districts

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)
7 188479 Prune Opt Out 3 Ceratonia siliqua :: Carob 5 2208 Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft Permit Number 787847 6010817.79084 2106032.71885 37.7633744862602 -122.405743691032 (37.7633744862602, -122.405743691032) 8 4 8 28859 19
21283 225084 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3784 22nd St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6003185.26448 2103031.00379 37.7547027131682 -122.431927750974 (37.7547027131682, -122.431927750974) 2 4 5 28862 22
24938 188478 DPW Maintained 1 Ceratonia siliqua :: Carob 5 499 San Bruno Ave 1 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   6010892.5271 2106015.01328 37.7633300498768 -122.405483954234 (37.7633300498768, -122.405483954234) 8 4 8 28856 19
27880 438 DPW Maintained 1 Ceratonia siliqua :: Carob 5 792X Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     80 6   6004975.0011312 2103729.1085203 37.7567208435744 -122.425788038834 (37.7567208435744, -122.425788038834) 2 4 5 28862 3
29270 103687 Undocumented 4 Ceratonia siliqua :: Carob 5 903 SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6008052 2102672 37.7539916655216 -122.415071798268 (37.7539916655216, -122.415071798268) 2 4 7 28859 19
29632 102874 Permitted Site 7 Ceratonia siliqua :: Carob 5 2761 21st St 3 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6009574.6 2103896.5 37.7574393136514 -122.409892695521 (37.7574393136514, -122.409892695521) 2 4 7 28859 19
30088 5432 DPW Maintained 1 Ceratonia siliqua :: Carob 5 499 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     36 3X3   6004968.15127 2105494.35348 37.7615674029223 -122.425937381218 (37.7615674029223, -122.425937381218) 8 4 5 28859 19
30477 222899 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3737 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 6ft   6005393.47694 2104277.70893 37.7582508111316 -122.424379813902 (37.7582508111316, -122.424379813902) 2 4 5 28859 19
32130 5658 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1349-1349 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     100 3X3   6005239.88286 2100530.07402 37.7479520016853 -122.42464442051 (37.7479520016853, -122.42464442051) 2 4 5 28859 19
34635 225051 DPW Maintained 1 Ceratonia siliqua :: Carob 5 4331 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6000881.81518 2102275.99981 37.7524988021808 -122.439839555559 (37.7524988021808, -122.439839555559) 2 4 5 28862 22
35456 225068 DPW Maintained 1 Ceratonia siliqua :: Carob 5 900 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6009114.1902 2103856.87983 37.7573047117606 -122.411482183163 (37.7573047117606, -122.411482183163) 2 4 7 28859 19
43272 105450 Undocumented 4 Ceratonia siliqua :: Carob 5 890 Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2           6009082.7 2103985.1 37.7576550089679 -122.411600148106 (37.7576550089679, -122.411600148106) 2 4 7 28859 19
48763 225089 DPW Maintained 1 Ceratonia siliqua :: Carob 5 838 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6004316.16009 2104019.9015 37.7574820391842 -122.428087274435 (37.7574820391842, -122.428087274435) 2 4 5 28862 3
56324 225070 DPW Maintained 1 Ceratonia siliqua :: Carob 5 890 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6009108.93583 2103990.98377 37.757672636103 -122.411509829221 (37.757672636103, -122.411509829221) 2 4 7 28859 19
62148 115558 Undocumented 4 Ceratonia siliqua :: Carob 5 2500x 19TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010357 2105131 37.7608727909959 -122.407273854716 (37.7608727909959, -122.407273854716) 10 4 8 28859 19
62291 5529 DPW Maintained 1 Ceratonia siliqua :: Carob 5 895 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     100 4X4   6005093.86648 2103161.82188 37.7551699235695 -122.425336590916 (37.7551699235695, -122.425336590916) 2 4 5 28859 19
63609 222900 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3733 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6005413.47026 2104278.82733 37.7582550109751 -122.424310747749 (37.7582550109751, -122.424310747749) 2 4 5 28859 19
63652 104633 Undocumented 4 Ceratonia siliqua :: Carob 5 850 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6009360 2104224 37.7583265252915 -122.410657998143 (37.7583265252915, -122.410657998143) 2 4 7 28859 19
64795 225045 DPW Maintained 1 Ceratonia siliqua :: Carob 5 881 Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6009145.12233 2103987.25914 37.7576644387915 -122.411384417877 (37.7576644387915, -122.411384417877) 2 4 7 28859 19
66277 222890 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2761 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6009529.18788 2103922.95806 37.757509416346 -122.4100516172 (37.757509416346, -122.4100516172) 2 4 7 28859 19
66742 225072 DPW Maintained 1 Ceratonia siliqua :: Carob 5 902 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6009377.02442 2103868.3997 37.7573510817046 -122.410574009103 (37.7573510817046, -122.410574009103) 2 4 7 28859 19
66852 222897 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2771 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009509.00989 2103333.02961 37.7558884746751 -122.41007975427 (37.7558884746751, -122.41007975427) 2 4 7 28859 19
70907 102876 Permitted Site 7 Ceratonia siliqua :: Carob 5 2761 21st St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009574.6 2103896.5 37.7574393136514 -122.409892695521 (37.7574393136514, -122.409892695521) 2 4 7 28859 19
72128 225047 DPW Maintained 1 Ceratonia siliqua :: Carob 5 971 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6009431.36633 2103539.27108 37.7564504151646 -122.410362833886 (37.7564504151646, -122.410362833886) 2 4 7 28859 19
74298 225086 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3689 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6003831.7176 2103603.4271 37.7563110786983 -122.429732966312 (37.7563110786983, -122.429732966312) 2 4 5 28862 22
77058 222893 DPW Maintained 1 Ceratonia siliqua :: Carob 5 301 Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 Width 4ft   6004914.2278 2106488.73534 37.7642946914815 -122.426194676362 (37.7642946914815, -122.426194676362) 8 4 5 28859 19
77339 225088 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3899 19th St 3 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   6003725.04695 2104766.83601 37.7594994820291 -122.430184865761 (37.7594994820291, -122.430184865761) 2 4 5 28862 3
77410 188477 DPW Maintained 1 Ceratonia siliqua :: Carob 5 499 San Bruno Ave 2 Sidewalk: Curb side : Yard Tree Private 2     16 Width 3ft   6010894.54885 2106022.42438 37.7633505121307 -122.405477483603 (37.7633505121307, -122.405477483603) 8 4 8 28856 19
82304 225073 DPW Maintained 1 Ceratonia siliqua :: Carob 5 904 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009377.25257 2103854.78979 37.7573137247548 -122.410572259011 (37.7573137247548, -122.410572259011) 2 4 7 28859 19
85099 225087 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3901 19th St 3 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   6003680.66693 2104762.35118 37.7594846540097 -122.430338033793 (37.7594846540097, -122.430338033793) 2 4 5 28862 3
86582 105449 Undocumented 4 Ceratonia siliqua :: Carob 5 890 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2           6009082.7 2103985.1 37.7576550089679 -122.411600148106 (37.7576550089679, -122.411600148106) 2 4 7 28859 19
90289 22896 Permitted Site 7 Ceratonia siliqua :: Carob 5 201 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     25 2X2   6006117.69751 2108447.07837 37.7697397858216 -122.422171347799 (37.7697397858216, -122.422171347799) 8 4 7 28853 19
95860 225078 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2844 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6009189.80262 2103948.11037 37.7575594510339 -122.411227129126 (37.7575594510339, -122.411227129126) 2 4 7 28859 19
97684 115557 Undocumented 4 Ceratonia siliqua :: Carob 5 2500x 19TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010357 2105131 37.7608727909959 -122.407273854716 (37.7608727909959, -122.407273854716) 10 4 8 28859 19
101361 222898 Undocumented 4 Ceratonia siliqua :: Carob 5 2771 22nd St 2 Sidewalk: Curb side : Yard Tree Private 2     21 Width 6ft   6009527.7031 2103333.93064 37.7558919964247 -122.410015170384 (37.7558919964247, -122.410015170384) 2 4 7 28859 19
108761 225075 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3334 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007507.05129 2101513.08881 37.750778919809 -122.416874263658 (37.750778919809, -122.416874263658) 2 4 7 28859 19
115384 225080 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2823 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009082.12028 2103902.99509 37.7574295349581 -122.411596352099 (37.7574295349581, -122.411596352099) 2 4 7 28859 19
117938 105930 Undocumented 4 Ceratonia siliqua :: Carob 5 971 Florida St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009455 2103552.4 37.7564877890416 -122.410282026926 (37.7564877890416, -122.410282026926) 2 4 7 28859 19
131158 5479 DPW Maintained 1 Ceratonia siliqua :: Carob 5 695 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 8   6005031.79334 2104320.15384 37.758346924379 -122.425633695438 (37.758346924379, -122.425633695438) 2 4 5 28859 19
131488 225048 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2823 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009293.07164 2103911.54746 37.7574648486362 -122.410867399417 (37.7574648486362, -122.410867399417) 2 4 7 28859 19
137377 225077 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2862 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     27 Width 3ft   6009020.65891 2103938.13075 37.7575225617285 -122.411811393486 (37.7575225617285, -122.411811393486) 2 4 7 28859 19
138379 222901 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2500 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6010350.92768 2105070.60578 37.7607066222297 -122.407290598708 (37.7607066222297, -122.407290598708) 10 4 8 28859 19
141583 225076 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3328 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6007533.56344 2101516.41809 37.7507895524966 -122.416782817886 (37.7507895524966, -122.416782817886) 2 4 7 28859 19
148016 222902 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2500 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6010304.7702 2105067.63235 37.760695874438 -122.407450027813 (37.760695874438, -122.407450027813) 10 4 8 28859 19
149886 5523 DPW Maintained 1 Ceratonia siliqua :: Carob 5 865 Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     50 3X3   6005084.41522 2103351.40166 37.7556899313628 -122.425382766602 (37.7556899313628, -122.425382766602) 2 4 5 28859 19
151186 222896 DPW Maintained 1 Ceratonia siliqua :: Carob 5 115 Julian Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6006441.81181 2107164.43854 37.7662362369242 -122.420959163358 (37.7662362369242, -122.420959163358) 8 4 7 28853 19
158043 222892 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2751 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6009588.6552 2103924.1994 37.7575161576583 -122.409846042069 (37.7575161576583, -122.409846042069) 2 4 7 28859 19
158465 188476 DPW Maintained 1 Ceratonia siliqua :: Carob 5 499 San Bruno Ave 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 3ft   6010896.57818 2106030.20806 37.7633719978287 -122.405471012994 (37.7633719978287, -122.405471012994) 8 4 8 28856 19
159275 225067 DPW Maintained 1 Ceratonia siliqua :: Carob 5 900 Alabama St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009115.2795 2103823.24781 37.7572124269416 -122.411476039894 (37.7572124269416, -122.411476039894) 2 4 7 28859 19
164614 225069 DPW Maintained 1 Ceratonia siliqua :: Carob 5 892 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6009108.56559 2103972.85995 37.7576228514299 -122.41150982923 (37.7576228514299, -122.41150982923) 2 4 7 28859 19
165457 225071 DPW Maintained 1 Ceratonia siliqua :: Carob 5 900 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009374.80383 2103883.56216 37.7573925899019 -122.410582759505 (37.7573925899019, -122.410582759505) 2 4 7 28859 19
166050 222891 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2759 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6009566.16928 2103923.02169 37.7575116637409 -122.409923724614 (37.7575116637409, -122.409923724614) 2 4 7 28859 19
166057 225074 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3354 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   6007335.7626 2101504.20622 37.7507448939762 -122.417465967185 (37.7507448939762, -122.417465967185) 2 4 7 28859 19
169536 222895 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3080 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft Permit Number 27054 6006273.18784 2106724.09401 37.7650176483701 -122.421511125848 (37.7650176483701, -122.421511125848) 8 4 7 28853 19
172314 225082 DPW Maintained 1 Ceratonia siliqua :: Carob 5 543 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   6002779.31526 2103257.03916 37.7553003306644 -122.433347783174 (37.7553003306644, -122.433347783174) 2 4 5 28862 22
172553 225079 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2804 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009325.52412 2103958.77383 37.7575963412133 -122.410758500511 (37.7575963412133, -122.410758500511) 2 4 7 28859 19
182657 5384 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325X Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     90 4X4   6004919.4864142 2106495.5645768 37.7643137401636 -122.426176974515 (37.7643137401636, -122.426176974515) 8 4 5 28859 19
184994 225046 DPW Maintained 1 Ceratonia siliqua :: Carob 5 901 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6009412.50008 2103884.66728 37.7573977376442 -122.41045246843 (37.7573977376442, -122.41045246843) 2 4 7 28859 19
185943 225083 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3782 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6003229.02977 2103031.88331 37.7547076090931 -122.431776461616 (37.7547076090931, -122.431776461616) 2 4 5 28862 22
193471 225085 DPW Maintained 1 Ceratonia siliqua :: Carob 5 406 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 5ft   6004142.31119 2101495.14459 37.7505398125629 -122.428508555547 (37.7505398125629, -122.428508555547) 2 4 5 28862 22
50898 49041 Permitted Site 7 Ceratonia siliqua :: Carob 5 406 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2003 12:00:00 AM     Permit Number 46216 6004132.32350443 2101573.22879489 37.7507536483556 -122.428548658976 (37.7507536483556, -122.428548658976) 2 4 5 28862 22
152653 51304 Permitted Site 7 Ceratonia siliqua :: Carob 5 4331 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767250 6001037.11613846 2102279.06351254 37.7525160532628 -122.439302719451 (37.7525160532628, -122.439302719451) 2 4 5 28862 22
33302 60693 Permitted Site 7 Ceratonia siliqua :: Carob 5 2762 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/1983 12:00:00 AM     Permit Number 20336 6009623.17116786 2103391.2059206 37.7560546117591 -122.409689051741 (37.7560546117591, -122.409689051741) 2 4 7 28859 19
112219 60684 Permitted Site 7 Ceratonia siliqua :: Carob 5 2969 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/1983 12:00:00 AM     Permit Number 20325 6009095.19054271 2102724.34950865 37.7541939732112 -122.411467881257 (37.7541939732112, -122.411467881257) 2 4 7 28859 19
136811 60690 Permitted Site 7 Ceratonia siliqua :: Carob 5 2773 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/1983 12:00:00 AM     Permit Number 20333 6009572.74299755 2103336.33183864 37.7559011138434 -122.409859576548 (37.7559011138434, -122.409859576548) 2 4 7 28859 19
154349 60691 Permitted Site 7 Ceratonia siliqua :: Carob 5 2767 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/1983 12:00:00 AM     Permit Number 20334 6009604.72609902 2103338.10407704 37.7559077723841 -122.409749093146 (37.7559077723841, -122.409749093146) 2 4 7 28859 19
161147 60694 Permitted Site 7 Ceratonia siliqua :: Carob 5 2770 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/1983 12:00:00 AM     Permit Number 20337 6009580.52702931 2103388.84293588 37.7560457337564 -122.409836363248 (37.7560457337564, -122.409836363248) 2 4 7 28859 19
113265 59009 Permitted Site 7 Ceratonia siliqua :: Carob 5 3737 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/1980 12:00:00 AM 15 4x4 Permit Number 18300 6005405.85335043 2104274.1193379 37.758241653827 -122.424336755524 (37.758241653827, -122.424336755524) 2 4 5 28859 19
25806 47316 Permitted Site 7 Ceratonia siliqua :: Carob 5 2524 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/2002 12:00:00 AM     Permit Number 45245 6010338.92838604 2105074.55283943 37.7607167883884 -122.407332377331 (37.7607167883884, -122.407332377331) 10 4 8 28859 19
161298 47317 Permitted Site 7 Ceratonia siliqua :: Carob 5 2524 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/10/2002 12:00:00 AM     Permit Number 45245 6010338.92838604 2105074.55283943 37.7607167883884 -122.407332377331 (37.7607167883884, -122.407332377331) 10 4 8 28859 19
115285 222894 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3080 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/14/1989 12:00:00 AM 14 Width 3ft Permit Number 27054 6006296.82054 2106727.45524 37.765028210007 -122.421429624803 (37.765028210007, -122.421429624803) 8 4 7 28853 19
95517 52077 Permitted Site 7 Ceratonia siliqua :: Carob 5 2959 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2005 12:00:00 AM     Permit Number 48273 6009147.75263717 2102727.30105861 37.7542050255745 -122.411286316307 (37.7542050255745, -122.411286316307) 2 4 7 28859 19
9140 48531 Permitted Site 7 Ceratonia siliqua :: Carob 5 500(REVISED) Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2002 12:00:00 AM     Permit Number 45857 6007225.9541014 2104383.62172477 37.7586449307205 -122.41804980128 (37.7586449307205, -122.41804980128) 2 4 7 28859 19
69517 48533 Permitted Site 7 Ceratonia siliqua :: Carob 5 500(REVISED) Capp St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2002 12:00:00 AM     Permit Number 45857 6007225.9541014 2104383.62172477 37.7586449307205 -122.41804980128 (37.7586449307205, -122.41804980128) 2 4 7 28859 19
185043 48532 Permitted Site 7 Ceratonia siliqua :: Carob 5 500(REVISED) Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2002 12:00:00 AM     Permit Number 45857 6007225.9541014 2104383.62172477 37.7586449307205 -122.41804980128 (37.7586449307205, -122.41804980128) 2 4 7 28859 19
119539 60259 Permitted Site 7 Ceratonia siliqua :: Carob 5 900 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/1989 12:00:00 AM     Permit Number 28050 6009367.15001104 2103917.51160129 37.7574853782949 -122.410611626923 (37.7574853782949, -122.410611626923) 2 4 7 28859 19
66042 60257 Permitted Site 7 Ceratonia siliqua :: Carob 5 911 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/10/1982 12:00:00 AM     Permit Number 19811 6009422.17813465 2103864.55146626 37.757343046708 -122.410417577389 (37.757343046708, -122.410417577389) 2 4 7 28859 19
162327 60271 Permitted Site 7 Ceratonia siliqua :: Carob 5 2761 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/10/1982 12:00:00 AM 12 3x3 Permit Number 19827 6009603.81924648 2103922.02713572 37.7575110429284 -122.409793445145 (37.7575110429284, -122.409793445145) 2 4 7 28859 19
123502 59722 Permitted Site 7 Ceratonia siliqua :: Carob 5 2905 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/14/1984 12:00:00 AM     Permit Number 19154 6008831.83417105 2103879.56302809 37.757351153159 -122.41246028798 (37.757351153159, -122.41246028798) 2 4 7 28859 19
20598 60264 Permitted Site 7 Ceratonia siliqua :: Carob 5 2804 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/1984 12:00:00 AM     Permit Number 19820 6009362.55423892 2103960.83669592 37.7576040815568 -122.410630580485 (37.7576040815568, -122.410630580485) 2 4 7 28859 19
143674 60260 Permitted Site 7 Ceratonia siliqua :: Carob 5 2844 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/1984 12:00:00 AM     Permit Number 19815 6009158.9675903 2103949.64001782 37.757561921733 -122.411333877594 (37.757561921733, -122.411333877594) 2 4 7 28859 19
192516 60263 Permitted Site 7 Ceratonia siliqua :: Carob 5 2781 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/1984 12:00:00 AM     Permit Number 19819 6009497.44754454 2103916.17692673 37.7574890178355 -122.410160909746 (37.7574890178355, -122.410160909746) 2 4 7 28859 19
54428 50386 Permitted Site 7 Ceratonia siliqua :: Carob 5 296 Liberty St 5 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532584 37.7573701836913 -122.427864268021 (37.7573701836913, -122.427864268021) 2 4 5 28862 3
99119 50383 Permitted Site 7 Ceratonia siliqua :: Carob 5 296 Liberty St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532584 37.7573701836913 -122.427864268021 (37.7573701836913, -122.427864268021) 2 4 5 28862 3
103441 50384 Permitted Site 7 Ceratonia siliqua :: Carob 5 296 Liberty St 7 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532584 37.7573701836913 -122.427864268021 (37.7573701836913, -122.427864268021) 2 4 5 28862 3
130611 50385 Permitted Site 7 Ceratonia siliqua :: Carob 5 296 Liberty St 6 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532584 37.7573701836913 -122.427864268021 (37.7573701836913, -122.427864268021) 2 4 5 28862 3
131762 50388 Permitted Site 7 Ceratonia siliqua :: Carob 5 296 Liberty St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532584 37.7573701836913 -122.427864268021 (37.7573701836913, -122.427864268021) 2 4 5 28862 3
131314 60288 Permitted Site 7 Ceratonia siliqua :: Carob 5 2932 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1982 12:00:00 AM     Permit Number 19852 6009284.44431761 2102786.94037008 37.754376447105 -122.410817812439 (37.754376447105, -122.410817812439) 2 4 7 28859 19

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