403 rows where qLegalStatus_id = 7 and qSpecies_id = 95 sorted by PlantDate

View and edit SQL

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)
1045 17359 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2221X Franklin St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6005488.40666 2117587.01663 37.7948002909451 -122.424998441372 (37.7948002909451, -122.424998441372) 13 9 1 28858 27
11325 92820 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 4410 Geary Blvd 12 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 53029 5993333.8 2112848.6 37.7810958286268 -122.466710108029 (37.7810958286268, -122.466710108029) 11 6 2 54 11
12757 27231 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 319X Silver Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6003407.79227 2093529.1013 37.7286252931888 -122.430480251933 (37.7286252931888, -122.430480251933) 9 7 6 28861 5
14941 22854 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 136 Turquoise Way 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   5999388.6872646 2099024.8421573 37.7434868046411 -122.444769353708 (37.7434868046411, -122.444769353708) 2 7 5 63 7
22333 1349 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 248 Amber Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3X3   5999719.4742299 2099231.8279857 37.7440740097154 -122.443640445364 (37.7440740097154, -122.443640445364) 2 7 5 63 22
22714 114635 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2201 Post St 3 Sidewalk: Curb side : Cutout Tree Private 2       2x2   6001638.4767595 2113898.3843624 37.7844540366015 -122.43805535523 (37.7844540366015, -122.43805535523) 15 6 11 29490 13
25693 10445 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1509 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     30 2X3   5998900.22539 2108626.72926 37.76982332449 -122.447149207323 (37.76982332449, -122.447149207323) 15 5 11 29492 9
28918 5016 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 5319 Diamond Heights Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     12 2   6001623.7265968 2098938.5095602 37.7433770497021 -122.43703498209 (37.7433770497021, -122.43703498209) 2 7 5 63 22
39422 23695 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2010X Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6005631.74009 2116915.10044 37.7929634737292 -122.424454671565 (37.7929634737292, -122.424454671565) 13 9 1 28858 27
40944 95611 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 345 08th Ave 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993380.9 2113168.3 37.7819763561044 -122.466570411383 (37.7819763561044, -122.466570411383) 11 6 2 54 11
43358 7984 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2040 Franklin St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6005624.48524 2117113.11255 37.7935067554767 -122.424493864894 (37.7935067554767, -122.424493864894) 13 9 1 28858 27
52690 2182 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1008 Broderick St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 4X4   6000953.66092 2112196.05676 37.7797409110638 -122.440302453138 (37.7797409110638, -122.440302453138) 15 5 11 29490 41
53963 84931 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 101 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 49345 6008717 2122460 37.8083621304447 -122.41417194996 (37.8083621304447, -122.41417194996) 3 1 10 308 23
57860 13384 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1000X Mansell St 10 Sidewalk: Curb side : Cutout Tree Rec/Park 5     12 3X3   6008956.7805816 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527) 9 7 7 309 18
59365 18544 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 61X Quartz Way 4 Sidewalk: Curb side : Cutout Tree Private 2     35 3X3   5999058.055369 2099782.1056805 37.7455471938994 -122.445967045704 (37.7455471938994, -122.445967045704) 2 7 5 63 22
64594 114637 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2201 Post St 5 Sidewalk: Curb side : Cutout Tree Private 2       2x2   6001638.4767595 2113898.3843624 37.7844540366015 -122.43805535523 (37.7844540366015, -122.43805535523) 15 6 11 29490 13
67766 9918 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1905X Gough St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5     20 3X3 Permit Number 768908 6005198.9827241 2116181.2464075 37.7909240477297 -122.425899774562 (37.7909240477297, -122.425899774562) 13 9 1 28858 27
67803 95610 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 345 08th Ave 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993380.9 2113168.3 37.7819763561044 -122.466570411383 (37.7819763561044, -122.466570411383) 11 6 2 54 11
71194 10383 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1327 Haight St 2 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   5999833.28029 2108766.34053 37.7702599294313 -122.443931836642 (37.7702599294313, -122.443931836642) 15 5 11 29492 9
85892 5030 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 5325 Diamond Heights Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     12 2   6001666.1669313 2098898.9593405 37.743270866325 -122.436885403782 (37.743270866325, -122.436885403782) 2 7 5 63 22
92555 9315 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 99X Gold Mine Dr 3 Sidewalk: Curb side : Cutout Tree Private 2     40 2X2   6001391.6487444 2098856.3848919 37.7431383606087 -122.437831565564 (37.7431383606087, -122.437831565564) 2 7 5 63 7
92769 9919 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1905X Gough St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5     20 3X3 Permit Number 768908 6005198.9827241 2116181.2464075 37.7909240477297 -122.425899774562 (37.7909240477297, -122.425899774562) 13 9 1 28858 27
101422 2576 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1666 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6005527.92113 2115186.27455 37.7882106874937 -122.424690849945 (37.7882106874937, -122.424690849945) 13 9 1 28858 41
102815 114636 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2201 Post St 4 Sidewalk: Curb side : Cutout Tree Private 2       2x2   6001638.4767595 2113898.3843624 37.7844540366015 -122.43805535523 (37.7844540366015, -122.43805535523) 15 6 11 29490 13
107904 1365 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 25 Amethyst Way 2 Sidewalk: Curb side : Cutout Tree Private 2     3 1X1   5999130.7643175 2100002.9435196 37.7461577128307 -122.445731509099 (37.7461577128307, -122.445731509099) 2 7 5 63 22
115342 17362 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2298X Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 3X3   6005094.42253 2117295.11988 37.7939765536908 -122.426340889125 (37.7939765536908, -122.426340889125) 13 9 1 28858 27
120111 9337 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 187 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     24 2X2   6000798.3699591 2098653.6744451 37.7425480118371 -122.439868429368 (37.7425480118371, -122.439868429368) 2 7 5 63 7
123897 9336 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 183 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     24 2X2   6000834.431691 2098665.006699 37.7425811802181 -122.439744551086 (37.7425811802181, -122.439744551086) 2 7 5 63 7
125252 9316 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 99X Gold Mine Dr 4 Sidewalk: Curb side : Cutout Tree Private 2     8 2X2   6001391.6487444 2098856.3848919 37.7431383606087 -122.437831565564 (37.7431383606087, -122.437831565564) 2 7 5 63 7
129961 114638 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2201 Post St 6 Sidewalk: Curb side : Cutout Tree Private 2       2x2   6001638.4767595 2113898.3843624 37.7844540366015 -122.43805535523 (37.7844540366015, -122.43805535523) 15 6 11 29490 13
140970 50962 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2544 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47454 6007484.88144152 2121079.14108349 37.8045013596833 -122.418338067384 (37.8045013596833, -122.418338067384) 5 1 1 308 32
143804 88992 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 680 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013080.3 2113726.9 37.784627230328 -122.398458274764 (37.784627230328, -122.398458274764) 6 2 9 28853 6
148957 11444 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2191X Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6005072.64937 2117089.85961 37.7934117301419 -122.426401604865 (37.7934117301419, -122.426401604865) 13 9 1 28858 27
150190 95609 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 345 08th Ave 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993380.9 2113168.3 37.7819763561044 -122.466570411383 (37.7819763561044, -122.466570411383) 11 6 2 54 11
166868 10321 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 759 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6002536.32245 2109085.56364 37.7712902545388 -122.434604866834 (37.7712902545388, -122.434604866834) 15 5 11 29492 9
168334 22790 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1002X BRODERICK ST 3 Sidewalk: Curb side : Cutout Tree Private 2     9 4X4   6000899 2112257 37.7799051333688 -122.440495920848 (37.7799051333688, -122.440495920848) 15 5 1 29490 41
187125 97314 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 939 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990332.7 2099029.1 37.7429775357045 -122.47608267022 (37.7429775357045, -122.47608267022) 1 8 3 29491 35
40120 66387 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 576 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1991 12:00:00 AM     Permit Number 29513 6003809.30522061 2109740.24975223 37.7731600457631 -122.430248280428 (37.7731600457631, -122.430248280428) 7 9 11 29492 10
137438 66370 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 710 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1991 12:00:00 AM     Permit Number 29494 6007739.56425491 2095629.41545125 37.7346367352991 -122.415653670559 (37.7346367352991, -122.415653670559) 2 7 7 28859 2
166941 66373 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 430 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1991 12:00:00 AM     Permit Number 29497 6003708.35294884 2109810.61822809 37.7733475417865 -122.430602509574 (37.7733475417865, -122.430602509574) 7 9 11 29492 10
84494 49046 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 115 Greenwood Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2003 12:00:00 AM     Permit Number 46219 5996108.27017141 2093728.07837669 37.7287554301635 -122.455729350835 (37.7287554301635, -122.455729350835) 9 7 4 28861 40
121400 49047 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 115 Greenwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2003 12:00:00 AM     Permit Number 46219 5996108.27017141 2093728.07837669 37.7287554301635 -122.455729350835 (37.7287554301635, -122.455729350835) 9 7 4 28861 40
175140 49058 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 634 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2003 12:00:00 AM     Permit Number 46225 5995429.55733009 2093557.30564002 37.7282475554757 -122.458063335473 (37.7282475554757, -122.458063335473) 9 7 4 28861 40
178593 49057 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 634 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2003 12:00:00 AM     Permit Number 46225 5995429.55733009 2093557.30564002 37.7282475554757 -122.458063335473 (37.7282475554757, -122.458063335473) 9 7 4 28861 40
7453 66398 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 510 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1991 12:00:00 AM     Permit Number 29524 6007445.87739968 2096478.55020646 37.7369517596137 -122.41672918389 (37.7369517596137, -122.41672918389) 2 7 7 28859 2
28609 66395 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 506 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1991 12:00:00 AM     Permit Number 29521 6007446.79828476 2096488.59897918 37.7369794031279 -122.41672671165 (37.7369794031279, -122.41672671165) 2 7 7 28859 2
61445 66389 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 711 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1991 12:00:00 AM     Permit Number 29515 6007791.32662379 2095624.44985276 37.7346260104333 -122.41547435861 (37.7346260104333, -122.41547435861) 2 7 7 28859 2
127118 66393 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 741 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1991 12:00:00 AM     Permit Number 29519 6007775.9235659 2095463.88536749 37.7341842695898 -122.415516248299 (37.7341842695898, -122.415516248299) 2 7 7 28859 2
1102 64618 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 355 Banks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1991 12:00:00 AM     Permit Number 29568 6008648.33494852 2097105.55483154 37.7387409360622 -122.412616048547 (37.7387409360622, -122.412616048547) 10 7 7 28859 2
43647 66445 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 276 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1991 12:00:00 AM     Permit Number 29591 6006234.06842317 2096062.82287391 37.7357420325633 -122.420889447827 (37.7357420325633, -122.420889447827) 2 7 7 28859 2
78134 66434 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 150 Highland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1991 12:00:00 AM     Permit Number 29577 6005801.93494772 2096621.96113828 37.7372529340664 -122.422423220071 (37.7372529340664, -122.422423220071) 2 7 7 28859 2
105348 66432 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 107 Highland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1991 12:00:00 AM     Permit Number 29575 6005403.67297656 2096707.579185 37.737465547355 -122.423806282291 (37.737465547355, -122.423806282291) 2 7 7 28859 2
186053 58261 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 284 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1991 12:00:00 AM     Permit Number 29595 6006300.27949858 2096057.24015103 37.7357304355186 -122.420660133777 (37.7357304355186, -122.420660133777) 2 7 7 28859 2
186651 66444 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 273 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1991 12:00:00 AM     Permit Number 29590 6006205.33193134 2096117.4303664 37.7358903527924 -122.420992677212 (37.7358903527924, -122.420992677212) 2 7 7 28859 2
20886 69078 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1230 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/10/1994 12:00:00 AM     Permit Number 33086 5992088.88490345 2107064.56024544 37.7651424933412 -122.470595450908 (37.7651424933412, -122.470595450908) 11 8 11 56 12
79755 69070 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1418 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/10/1994 12:00:00 AM     Permit Number 33078 5991822.68540229 2105767.59730493 37.7615659811295 -122.471421651008 (37.7615659811295, -122.471421651008) 1 8 4 56 12
27708 62501 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 553 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/1986 12:00:00 AM     Permit Number 22676 6001215.07825091 2103108.27650352 37.7548029979447 -122.438746711531 (37.7548029979447, -122.438746711531) 2 4 5 28862 22
41371 62502 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 559 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/1986 12:00:00 AM     Permit Number 22677 6001216.54610272 2103082.94453689 37.754733525989 -122.438739820196 (37.754733525989, -122.438739820196) 2 4 5 28862 22
59789 62500 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 545 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/1986 12:00:00 AM     Permit Number 22675 6001213.12111484 2103142.05246429 37.7548956272315 -122.438755899998 (37.7548956272315, -122.438755899998) 2 4 5 28862 22
63215 62507 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 446 Eureka St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/1986 12:00:00 AM     Permit Number 22683 6001488.09473813 2103175.70206987 37.755003660534 -122.437807375939 (37.755003660534, -122.437807375939) 2 4 5 28862 22
126958 62504 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 571 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/1986 12:00:00 AM     Permit Number 22679 6001219.48180727 2103032.28058785 37.7545945820306 -122.438726037561 (37.7545945820306, -122.438726037561) 2 4 5 28862 22
51210 62521 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 4160 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/1986 12:00:00 AM     Permit Number 22703 6001328.95077887 2102932.2644915 37.7543261890061 -122.438340300549 (37.7543261890061, -122.438340300549) 2 4 5 28862 22
132791 62525 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 4225 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/1986 12:00:00 AM     Permit Number 22707 6001046.89460129 2102865.04876226 37.7541255838915 -122.439310902564 (37.7541255838915, -122.439310902564) 2 4 5 28862 22
156689 62526 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 4239 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/1986 12:00:00 AM     Permit Number 22708 6000961.55320183 2102860.47332895 37.7541081639689 -122.439605705302 (37.7541081639689, -122.439605705302) 2 4 5 28862 22
79650 66965 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2240 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/1992 12:00:00 AM     Permit Number 30304 5998818.1489721 2111475.13282444 37.7776396217275 -122.447638180901 (37.7776396217275, -122.447638180901) 15 6 2 54 16
53445 63259 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 58 Bonview St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/23/1987 12:00:00 AM     Permit Number 23812 6007675.47981735 2099150.37984096 37.7443009239155 -122.41612450988 (37.7443009239155, -122.41612450988) 2 7 7 28859 2
100685 61788 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1269 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1985 12:00:00 AM     Permit Number 21810 6011996.7545231 2102487.05036532 37.7537047233984 -122.401416818367 (37.7537047233984, -122.401416818367) 10 3 8 28856 29
24186 62951 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1795 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1987 12:00:00 AM     Permit Number 23833 6002734.78397825 2113355.91233134 37.7830268313176 -122.434223718554 (37.7830268313176, -122.434223718554) 15 9 11 29490 41
43483 63273 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2049 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1987 12:00:00 AM     Permit Number 23832 6001545.00229536 2113189.36055962 37.7825019218083 -122.438327931003 (37.7825019218083, -122.438327931003) 15 5 11 29490 41
131737 63271 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1800 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1987 12:00:00 AM     Permit Number 23830 6001386.26443426 2112180.71364321 37.7797234038821 -122.438804791999 (37.7797234038821, -122.438804791999) 15 5 11 29490 41
9102 83833 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1220 La Playa St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2008 12:00:00 AM   3x3 Permit Number 50199 5980896.51884717 2106747.16910548 37.7636174777723 -122.509282857292 (37.7636174777723, -122.509282857292) 1 8 3 56 35
115361 83929 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1220 La Playa St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2008 12:00:00 AM   3x3 Permit Number 50199 5980896.51884717 2106747.16910548 37.7636174777723 -122.509282857292 (37.7636174777723, -122.509282857292) 1 8 3 56 35
19031 63323 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 51 Mullen Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/30/1987 12:00:00 AM     Permit Number 23896 6009520.68334064 2099892.76557609 37.746442929173 -122.409796554578 (37.746442929173, -122.409796554578) 2 7 7 28859 2
40097 69202 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2834 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1994 12:00:00 AM     Permit Number 33250 6008944.32524952 2101948.50839104 37.7520552245421 -122.411934790422 (37.7520552245421, -122.411934790422) 2 4 7 28859 19
121551 30727 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 45 Rose St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM     Permit Number 34624 6006303.86733164 2109861.47838862 37.7736338888904 -122.421627862373 (37.7736338888904, -122.421627862373) 7 9 11 28852 10
31098 63328 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 75 Mullen Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/02/1987 12:00:00 AM     Permit Number 23901 6009622.07115368 2099898.67232456 37.7464648291666 -122.409446382283 (37.7464648291666, -122.409446382283) 2 7 7 28859 2
157627 63327 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 67 Mullen Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/02/1987 12:00:00 AM     Permit Number 23900 6009588.27522653 2099896.70340901 37.7464575292866 -122.409563106368 (37.7464575292866, -122.409563106368) 2 7 7 28859 2
61985 60427 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 426 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1996 12:00:00 AM     Permit Number 20011 6003800.98811791 2098974.33117024 37.7435989232844 -122.429509123627 (37.7435989232844, -122.429509123627) 2 7 5 63 22
21107 58677 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 142 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/1983 12:00:00 AM     Permit Number 20288 6004283.38599027 2097405.52604754 37.7393186445117 -122.427729355445 (37.7393186445117, -122.427729355445) 2 7 5 63 7
23097 60652 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 125 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/1983 12:00:00 AM     Permit Number 20284 6004314.87851567 2097476.26675857 37.7395146637963 -122.427625506935 (37.7395146637963, -122.427625506935) 2 7 5 63 7
73999 60651 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 119 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/1983 12:00:00 AM     Permit Number 20282 6004308.90872875 2097494.4365772 37.7395642163021 -122.42764744207 (37.7395642163021, -122.42764744207) 2 7 5 63 7
95043 60653 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 135 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/1983 12:00:00 AM     Permit Number 20285 6004324.82816302 2097445.98371997 37.7394320762559 -122.427588948431 (37.7394320762559, -122.427588948431) 2 7 5 63 7
166556 60669 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 274 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/1983 12:00:00 AM     Permit Number 20303 6004309.8735522 2096796.94934371 37.7376491294631 -122.427594426597 (37.7376491294631, -122.427594426597) 2 7 5 63 7
44095 61324 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 644 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/14/1984 12:00:00 AM     Permit Number 21227 6000113.71348452 2111091.95490502 37.776661470532 -122.443128871484 (37.776661470532, -122.443128871484) 15 5 11 29492 16
109533 61327 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1939 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/14/1984 12:00:00 AM     Permit Number 21230 5999877.32388758 2111224.65022553 37.7770123365346 -122.443956146179 (37.7770123365346, -122.443956146179) 15 5 11 29492 16
114831 61328 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1945 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/14/1984 12:00:00 AM     Permit Number 21231 5999849.86914689 2111220.88656755 37.7770004363515 -122.444050849823 (37.7770004363515, -122.444050849823) 15 5 11 29492 16
34446 63419 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 360 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/20/1987 12:00:00 AM     Permit Number 24003 6007037.15561138 2095995.10883407 37.7356013393444 -122.418108057323 (37.7356013393444, -122.418108057323) 2 7 7 28859 2
133519 63420 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 331 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/20/1987 12:00:00 AM     Permit Number 24004 6006758.70669119 2096070.77138745 37.7357934155669 -122.419076128909 (37.7357934155669, -122.419076128909) 2 7 7 28859 2
124337 67013 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1345 Ocean Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/20/1992 12:00:00 AM     Permit Number 30368 5995769.70652962 2091972.54890953 37.7239157311453 -122.456772865671 (37.7239157311453, -122.456772865671) 9 8 4 28861 24
107187 50782 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1191 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/25/2004 12:00:00 AM     Permit Number 47308 6008219.78042798 2115855.19241784 37.7901990348064 -122.415424817486 (37.7901990348064, -122.415424817486) 5 1 10 28858 21
42140 61736 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 221 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/29/1992 12:00:00 AM     Permit Number 21741 6003726.68800043 2100963.99534524 37.7490578720388 -122.429907929601 (37.7490578720388, -122.429907929601) 2 4 5 28862 22
124906 62567 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 566 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/1986 12:00:00 AM     Permit Number 22768 6011492.88408448 2105735.21386833 37.7625953337074 -122.403387819029 (37.7625953337074, -122.403387819029) 8 3 8 28856 29
166566 62573 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 801 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/1986 12:00:00 AM     Permit Number 22776 6011595.8787413 2104633.73265 37.7595766638959 -122.402954119848 (37.7595766638959, -122.402954119848) 10 3 8 28856 29
63960 63440 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 312 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/1987 12:00:00 AM     Permit Number 24027 6006584.64694822 2096033.26310282 37.735680622673 -122.419675262327 (37.735680622673, -122.419675262327) 2 7 7 28859 2
87480 63437 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 344 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/1987 12:00:00 AM     Permit Number 24024 6006886.3193962 2096007.82692315 37.7356277694356 -122.418630458599 (37.7356277694356, -122.418630458599) 2 7 7 28859 2
117669 63436 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 345 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/1987 12:00:00 AM     Permit Number 24023 6006890.68838828 2096059.64305875 37.7357702910917 -122.418619026584 (37.7357702910917, -122.418619026584) 2 7 7 28859 2
156480 63434 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 386 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/1987 12:00:00 AM     Permit Number 24020 6007282.26446985 2095974.44193855 37.7355583855051 -122.417259156011 (37.7355583855051, -122.417259156011) 2 7 7 28859 2
104821 64268 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 3 MacEdonia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/1988 12:00:00 AM     Permit Number 25071 6010264.47432516 2099824.85360013 37.7462981125223 -122.407219810784 (37.7462981125223, -122.407219810784) 2 7 7 28859 2
136759 59579 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 927 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/07/1981 12:00:00 AM     Permit Number 18970 6003789.07687713 2102877.39607129 37.7543151544522 -122.429828648461 (37.7543151544522, -122.429828648461) 2 4 5 28862 22
150267 67037 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 620 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1992 12:00:00 AM     Permit Number 30412 6004248.3695844 2105283.39712956 37.7609474626645 -122.428411775349 (37.7609474626645, -122.428411775349) 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)
);