Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 110567 | 110567 | 51442 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 775 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/19/2004 12:00:00 AM | Permit Number 47761 | 6007380.25742092 | 2095203.71769531 | 37.7334476580973 | -122.41686576869301 | (37.7334476580973, -122.416865768693) | ||
| 38728 | 38728 | 200604 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 61 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016455.981000001 | 2095075.886 | 37.7336029770488 | -122.385479227084 | (37.7336029770488, -122.385479227084) | |||
| 137132 | 137132 | 200619 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 60 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016453.0429 | 2095085.1899 | 37.733628361140106 | -122.38549003320101 | (37.7336283611401, -122.385490033201) | |||
| 30866 | 30866 | 200618 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 59 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6016445.2081 | 2095088.6176 | 37.733637339432 | -122.38551735943399 | (37.733637339432, -122.385517359434) | |||
| 76733 | 76733 | 200616 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 57 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016436.8835 | 2095099.8803 | 37.7336678039609 | -122.385546924914 | (37.7336678039609, -122.385546924914) | |||
| 72294 | 72294 | 200614 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 55 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6016432.4764 | 2095111.6325 | 37.73369982930821 | -122.385562980445 | (37.7336998293082, -122.385562980445) | |||
| 76333 | 76333 | 200612 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 53 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6016428.558999999 | 2095128.7713 | 37.7337466722751 | -122.385577718213 | (37.7337466722751, -122.385577718213) | |||
| 154023 | 154023 | 207128 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 0ft | 5991324.62806 | 2095649.6189400002 | 37.7337558092758 | -122.472406573513 | (37.7337558092758, -122.472406573513) | |||
| 55201 | 55201 | 218280 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 Woodacre Dr | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | 5991369.16642 | 2095649.3447099999 | 37.7337576340075 | -122.47225257269301 | (37.7337576340075, -122.472252572693) | ||||
| 72315 | 72315 | 207127 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 5991327.69264 | 2095651.06492 | 37.7337599569436 | -122.472396083831 | (37.7337599569436, -122.472396083831) | |||
| 60545 | 60545 | 207126 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 5991329.52565 | 2095655.7745299998 | 37.733772994434204 | -122.472390089849 | (37.7337729944342, -122.472390089849) | |||
| 53270 | 53270 | 207125 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 5991332.892440001 | 2095658.5010099998 | 37.733780675521395 | -122.47237864866001 | (37.7337806755214, -122.47237864866) | |||
| 53381 | 53381 | 217850 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 Woodacre Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 5991375.86862 | 2095660.38148 | 37.7337883260711 | -122.47223020566999 | (37.7337883260711, -122.47223020567) | ||||
| 188736 | 188736 | 207124 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 0ft | 5991335.55729 | 2095661.67857 | 37.7337895545331 | -122.472369667134 | (37.7337895545331, -122.472369667134) | |||
| 179845 | 179845 | 207123 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 5991338.6165 | 2095665.48618 | 37.733800186326604 | -122.472359368113 | (37.7338001863266, -122.472359368113) | |||
| 184814 | 184814 | 207122 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 5991343.33969 | 2095670.4637 | 37.7338141267018 | -122.47234340152399 | (37.7338141267018, -122.472343401524) | |||
| 180846 | 180846 | 207121 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | Width 0ft | 5991346.9817 | 2095677.27593 | 37.733833042151105 | -122.47233130655898 | (37.7338330421511, -122.472331306559) | |||
| 178438 | 178438 | 207120 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 5991349.86178 | 2095682.72956 | 37.7338481831293 | -122.472321746778 | (37.7338481831293, -122.472321746778) | |||
| 158536 | 158536 | 207119 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 0ft | 5991353.65823 | 2095688.25461 | 37.733863573243205 | -122.47230902406099 | (37.7338635732432, -122.472309024061) | |||
| 174722 | 174722 | 207118 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | Width 0ft | 5991361.11034 | 2095702.06647 | 37.7339019284143 | -122.472284266614 | (37.7339019284143, -122.472284266614) | |||
| 51787 | 51787 | 217831 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 5991381.66969 | 2095739.8250799999 | 37.734006793868 | -122.472215938837 | (37.734006793868, -122.472215938837) | ||||
| 141290 | 141290 | 48774 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 629 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2004 12:00:00 AM | Permit Number 47773 | 6007825.24973386 | 2095718.75627166 | 37.7348868619711 | -122.415363748684 | (37.7348868619711, -122.415363748684) | ||
| 98528 | 98528 | 47604 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 645 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/2002 12:00:00 AM | Permit Number 45440 | 6008713.69382569 | 2095849.48701302 | 37.7352957148385 | -122.412301312985 | (37.7352957148385, -122.412301312985) | ||
| 105148 | 105148 | 52497 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 371 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48606 | 6007135.79724675 | 2096038.97616324 | 37.7357273409345 | -122.417770123047 | (37.7357273409345, -122.417770123047) | ||
| 107598 | 107598 | 82810 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2730 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50728 | 5983104.2980141 | 2096628.76061893 | 37.735965062583205 | -122.500898621502 | (37.7359650625832, -122.500898621502) | ||
| 143931 | 143931 | 82814 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2724 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50727 | 5983103.67908303 | 2096652.63979189 | 37.7360305919754 | -122.500902526777 | (37.7360305919754, -122.500902526777) | ||
| 122974 | 122974 | 79279 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2706 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50726 | 5983101.82229012 | 2096724.27729962 | 37.7362271801162 | -122.50091424264 | (37.7362271801162, -122.50091424264) | ||
| 88035 | 88035 | 34348 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 330 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38106 | 6004294.50938701 | 2096370.47715627 | 37.7364772644099 | -122.42761717220199 | (37.7364772644099, -122.427617172202) | ||
| 135684 | 135684 | 183373 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2728 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985578.5174 | 2096788.4906 | 37.736548599668104 | -122.492356136884 | (37.7365485996681, -122.492356136884) | |||
| 182990 | 182990 | 182942 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2671 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982115.1 | 2096931.8144 | 37.736739035882394 | -122.504341059874 | (37.7367390358824, -122.504341059874) | |||
| 166550 | 166550 | 227682 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 500 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008186.7931 | 2096476.1256400002 | 37.7369867469298 | -122.41416732857999 | (37.7369867469298, -122.41416732858) | |||
| 85274 | 85274 | 52492 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 390ON GATES Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48601 | 6008184.68107457 | 2096494.82661811 | 37.7370379770988 | -122.41417595350599 | (37.7370379770988, -122.414175953506) | ||
| 18415 | 18415 | 13417 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 400 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 5 | 5999553.15658 | 2097034.9165400001 | 37.7380323275191 | -122.444057708717 | (37.7380323275191, -122.444057708717) | |||
| 108468 | 108468 | 1383 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2550X Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X2 | 6002248.65699 | 2096984.18535 | 37.7380464314256 | -122.434734413124 | (37.7380464314256, -122.434734413124) | |||
| 61815 | 61815 | 227684 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2560 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002253.36783 | 2096984.49578 | 37.7380475512412 | -122.434718147625 | (37.7380475512412, -122.434718147625) | |||
| 37269 | 37269 | 227675 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 104 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6005040.407269999 | 2096975.5643799999 | 37.7381808604543 | -122.425081325568 | (37.7381808604543, -122.425081325568) | ||||
| 127692 | 127692 | 63441 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 299 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1997 12:00:00 AM | Permit Number 24028 | 6008993.82853707 | 2096920.83270323 | 37.738253113659 | -122.411408443517 | (37.738253113659, -122.411408443517) | ||
| 180188 | 180188 | 227692 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 75 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006684.36987 | 2096973.81613 | 37.738268789882795 | -122.419397184857 | (37.7382687898828, -122.419397184857) | |||
| 148496 | 148496 | 227674 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 83 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005065.1015800005 | 2097012.05309 | 37.7382824451638 | -122.42499854026899 | (37.7382824451638, -122.424998540269) | ||||
| 178085 | 178085 | 227673 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 64 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6005078.09924 | 2097049.5351099998 | 37.738386096529204 | -122.424956266738 | (37.7383860965292, -122.424956266738) | ||||
| 150938 | 150938 | 227672 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 62 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005095.2123 | 2097053.48648 | 37.7383979127325 | -122.42489737911801 | (37.7383979127325, -122.424897379118) | ||||
| 74734 | 74734 | 227671 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 60 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6005087.18528 | 2097058.7145599998 | 37.738411814457706 | -122.42492550452101 | (37.7384118144577, -122.424925504521) | ||||
| 126240 | 126240 | 31667 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2571 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1995 12:00:00 AM | Permit Number 35175 | 5981777.56166178 | 2097600.02639588 | 37.7385539042174 | -122.505557573977 | (37.7385539042174, -122.505557573977) | ||
| 154014 | 154014 | 227691 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 309 Bocana St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6006868.9204400005 | 2097195.64462 | 37.7388882743696 | -122.418774826116 | (37.7388882743696, -122.418774826116) | |||
| 29076 | 29076 | 227690 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 307 Bocana St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6006885.1558 | 2097215.40267 | 37.7389434396991 | -122.41872009246299 | (37.7389434396991, -122.418720092463) | |||
| 126023 | 126023 | 40449 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 255 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47061 | 6008102.60669454 | 2097399.44811028 | 37.7395172589666 | -122.414523716357 | (37.7395172589666, -122.414523716357) | ||
| 78902 | 78902 | 52384 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 36TA MARINA Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | Permit Number 48509 | 6005730.58900637 | 2097520.8738626 | 37.739717121816604 | -122.422733759035 | (37.7397171218166, -122.422733759035) | ||
| 173767 | 173767 | 83228 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4234 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50748 | 5982916.47531802 | 2098139.9083931 | 37.740103232807705 | -122.50165975231 | (37.7401032328077, -122.50165975231) | |
| 186526 | 186526 | 183209 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4212 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5982952.5112 | 2098143.3306 | 37.740114745803204 | -122.501535410067 | (37.7401147458032, -122.501535410067) | |||
| 189013 | 189013 | 183208 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4208 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5982977.5431 | 2098144.6836 | 37.74011993093129 | -122.501448961428 | (37.7401199309313, -122.501448961428) | |||
| 117463 | 117463 | 46381 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2495 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | Permit Number 44618 | 5983000.42559938 | 2098163.19803029 | 37.740172110361705 | -122.501371213543 | (37.7401721103617, -122.501371213543) | ||
| 121341 | 121341 | 46382 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2495 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | Permit Number 44618 | 5983000.42559938 | 2098163.19803029 | 37.740172110361705 | -122.501371213543 | (37.7401721103617, -122.501371213543) | ||
| 169951 | 169951 | 183438 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2506 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5988326.6233 | 2098215.7152 | 37.7406276663345 | -122.48295944841401 | (37.7406276663345, -122.482959448414) | |||
| 48955 | 48955 | 183430 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2508 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988945.948 | 2098228.8968 | 37.7406998772059 | -122.480819050828 | (37.7406998772059, -122.480819050828) | |||
| 36322 | 36322 | 183431 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2506 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988944.9633 | 2098242.4359999998 | 37.740736995081704 | -122.480823446497 | (37.7407369950817, -122.480823446497) | |||
| 96706 | 96706 | 52103 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 641 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | Permit Number 48295 | 5997742.5728031 | 2098061.02519693 | 37.7407463206184 | -122.450391713191 | (37.7407463206184, -122.450391713191) | ||
| 130073 | 130073 | 227688 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 269 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007769.10714 | 2097866.49845 | 37.740780934479794 | -122.41570987722 | (37.7407809344798, -122.41570987722) | |||
| 128843 | 128843 | 47111 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 189 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45095 | 6007076.38254046 | 2097931.15674799 | 37.740919506174706 | -122.41810964654499 | (37.7409195061747, -122.418109646545) |
| 35457 | 35457 | 46390 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2447 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 7 | Permit Number 44623 | 5982678.99712077 | 2098464.70885711 | 37.7409810943186 | -122.502504874921 | (37.7409810943186, -122.502504874921) | |
| 86481 | 86481 | 52106 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 727 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | Permit Number 48298 | 5997405.05193713 | 2098248.96190456 | 37.741243026323 | -122.451572279627 | (37.741243026323, -122.451572279627) | ||
| 127237 | 127237 | 50114 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1252 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46839 | 5992244.12505327 | 2098460.15223335 | 37.7415260004029 | -122.469432140867 | (37.7415260004029, -122.469432140867) | ||
| 102052 | 102052 | 23670 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 317 Virginia Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 12 | 6006937.941544901 | 2098264.8464559 | 37.7418279505329 | -122.41861198258002 | (37.7418279505329, -122.41861198258) | |||
| 59085 | 59085 | 185502 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2400 Sunset Blvd | 56 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 5985117.0889 | 2098738.1726 | 37.7418749156753 | -122.494095121998 | (37.7418749156753, -122.494095121998) | |||
| 101609 | 101609 | 43632 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1001 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50556 | 5996213.47474732 | 2098545.79305022 | 37.7419897418411 | -122.455713757113 | (37.7419897418411, -122.455713757113) | ||
| 65093 | 65093 | 185504 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2400 Sunset Blvd | 58 | unknown : Yard 19 | Tree 1 | Private 1 | 6 | Width 0ft | 5985115.0968 | 2098786.6474 | 37.7420078978362 | -122.49410558184499 | (37.7420078978362, -122.494105581845) | |||
| 91138 | 91138 | 47550 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1681 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45414 | 6003392.60348895 | 2098449.5926945 | 37.7421349817765 | -122.430883775787 | (37.7421349817765, -122.430883775787) | ||
| 188108 | 188108 | 247870 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 394 Mayflower St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6009721.06953 | 2098395.0417 | 37.74234173489771 | -122.40899798048099 | (37.7423417348977, -122.408997980481) | ||||
| 33669 | 33669 | 247869 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 394 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6009720.84865 | 2098403.35069 | 37.7423645372013 | -122.408999330354 | (37.7423645372013, -122.408999330354) | ||||
| 123417 | 123417 | 247871 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 394 Mayflower St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6009746.3542 | 2098404.30325 | 37.742368581453704 | -122.40891120669201 | (37.7423685814537, -122.408911206692) | ||||
| 35370 | 35370 | 248189 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 216 Esmeralda Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6007400.67054 | 2098728.2959 | 37.7431265201804 | -122.417044843446 | (37.7431265201804, -122.417044843446) | ||||
| 42954 | 42954 | 79486 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2323 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 0 | 3x3 | Permit Number 50743 | 5981719.67239804 | 2099271.03998771 | 37.7431386384508 | -122.505881575612 | (37.7431386384508, -122.505881575612) | |
| 92573 | 92573 | 31375 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 630 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | Permit Number 34977 | 5991276.37232485 | 2099107.33925567 | 37.7432470351435 | -122.47282544581499 | (37.7432470351435, -122.472825445815) | ||
| 128729 | 128729 | 105136 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 175X ESMERALDA AVE | 2 | unknown : Yard 19 | Tree 1 | DPW 2 | 6007213.0 | 2098808.0 | 37.7433348108676 | -122.41769940776301 | (37.7433348108676, -122.417699407763) | |||||
| 94398 | 94398 | 116654 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 199x Esmeralda Ave | 9 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | |||||
| 95215 | 95215 | 116655 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 199x Esmeralda Ave | 9 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | |||||
| 95391 | 95391 | 113478 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100x ESMERALDA AVE | 5 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 8 | 6006917.0 | 2098966.0 | 37.7437519821991 | -122.418734104398 | (37.7437519821991, -122.418734104398) | ||||
| 95944 | 95944 | 116681 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100 Esmeralda Ave | 20 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 113611 | 113611 | 84886 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3138 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49329 | 5983290.0 | 2099514.0 | 37.7438980447125 | -122.500469849117 | (37.7438980447125, -122.500469849117) | |||
| 159861 | 159861 | 227676 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 427 Valley St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6003106.32375 | 2099187.31259 | 37.7441443647786 | -122.431926305762 | (37.7441443647786, -122.431926305762) | ||||
| 172830 | 172830 | 84447 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2266 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50738 | 5982378.18226568 | 2099687.61773546 | 37.744321183805106 | -122.503635505549 | (37.7443211838051, -122.503635505549) | |
| 123731 | 123731 | 227678 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6003889.89165 | 2099268.52237 | 37.744411737711296 | -122.42922269007799 | (37.7444117377113, -122.429222690078) | |||
| 66597 | 66597 | 227677 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003907.029080001 | 2099270.15617 | 37.7444171939021 | -122.42916354887801 | (37.7444171939021, -122.429163548878) | |||
| 95135 | 95135 | 50288 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797933998 | 37.744430384839504 | -122.42903293346001 | (37.7444303848395, -122.42903293346) | ||
| 95217 | 95217 | 50293 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797933998 | 37.744430384839504 | -122.42903293346001 | (37.7444303848395, -122.42903293346) | ||
| 100951 | 100951 | 50290 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 3x3 | Permit Number 47005 | 6003944.88624926 | 2099274.1797933998 | 37.744430384839504 | -122.42903293346001 | (37.7444303848395, -122.42903293346) | |
| 102346 | 102346 | 50292 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 3x3 | Permit Number 47005 | 6003944.88624926 | 2099274.1797933998 | 37.744430384839504 | -122.42903293346001 | (37.7444303848395, -122.42903293346) | |
| 126667 | 126667 | 50289 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797933998 | 37.744430384839504 | -122.42903293346001 | (37.7444303848395, -122.42903293346) | ||
| 145101 | 145101 | 50291 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797933998 | 37.744430384839504 | -122.42903293346001 | (37.7444303848395, -122.42903293346) | ||
| 185081 | 185081 | 227680 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1541 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003988.609540001 | 2099295.3111900003 | 37.7444908816604 | -122.428883253577 | (37.7444908816604, -122.428883253577) | |||
| 159182 | 159182 | 78557 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2234 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2016 12:00:00 AM | 3 | Permit Number 771299 | 5981748.2661 | 2099861.5988 | 37.7447618317919 | -122.505826480334 | (37.7447618317919, -122.505826480334) | |
| 146129 | 146129 | 49012 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 361 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2002 12:00:00 AM | Permit Number 46198 | 6003561.60300767 | 2099494.42119752 | 37.7450134133041 | -122.430373957908 | (37.7450134133041, -122.430373957908) | |||
| 67932 | 67932 | 227679 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 361 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003556.92712 | 2099495.0366599998 | 37.745014838355395 | -122.430390170187 | (37.7450148383554, -122.430390170187) | |||
| 115918 | 115918 | 34621 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 370 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2016 12:00:00 AM | 3 | Permit Number 778228 | 6003497.10528776 | 2099542.95496323 | 37.7451430220882 | -122.430600441889 | (37.7451430220882, -122.430600441889) | |
| 28427 | 28427 | 83251 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2210 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50737 | 5982365.40001882 | 2100051.8832382 | 37.7453206044327 | -122.503706674483 | (37.7453206044327, -122.503706674483) | |
| 49254 | 49254 | 48530 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2251(REVISED) 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2002 12:00:00 AM | 6 | Permit Number 45852 | 5988214.95937948 | 2099991.18132471 | 37.7454961303111 | -122.48347566224899 | (37.7454961303111, -122.483475662249) | |
| 61754 | 61754 | 227689 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 84 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008214.299790001 | 2099586.39862 | 37.7455284159971 | -122.41429222281 | (37.7455284159971, -122.41429222281) | |||
| 163773 | 163773 | 83208 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3634 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50746 | 5981914.57527844 | 2100148.1004138 | 37.7455582728462 | -122.505272655065 | (37.7455582728462, -122.505272655065) | |
| 65265 | 65265 | 83279 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2147 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50736 | 5982298.449010201 | 2100494.71161235 | 37.7465325514695 | -122.503970969286 | (37.7465325514695, -122.503970969286) | |
| 110762 | 110762 | 68097 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 49 Bessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31842 | 6008240.85722104 | 2100065.07433688 | 37.746844244689605 | -122.414234251858 | (37.7468442446896, -122.414234251858) | ||
| 173361 | 173361 | 46399 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2110 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 5 | Permit Number 44629 | 5981721.80383178 | 2100709.75793181 | 37.7470890826019 | -122.505980852245 | (37.7470890826019, -122.505980852245) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");